A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://gitlab.com/postgres-ai/joe/-/merge_requests/175 below:

feat: show locks for a single query analyzed with EXPLAIN (#189) (!175) · Merge requests · Postgres AI

Skip to content feat: show locks for a single query analyzed with EXPLAIN (#189)

Show locks for a single query analyzed with EXPLAIN

Closes #189 (closed)

Example

explain select * from pgbench_accounts;

Session: 20716

Plan with execution:
 Seq Scan on public.pgbench_accounts  (cost=0.00..1055738.16 rows=40000016 width=97) (actual time=0.121..7760.601 rows=40000000 loops=1)
   Buffers: shared read=655738
   I/O Timings: read=4944.735 write=0.000

Query pg_locks:

  RELKIND | RELNAMESPACE |        RELNAME        | BELONGS TO RELATION | LOCKTYPE |      MODE       | GRANTED | FASTPATH  
----------+--------------+-----------------------+---------------------+----------+-----------------+---------+-----------
  r       | public       | pgbench_accounts      | pgbench_accounts    | relation | AccessShareLock | true    | true      
  i       | public       | pgbench_accounts_pkey | pgbench_accounts    | relation | AccessShareLock | true    | true
Edited Jul 26, 2023 by Artyom Kartasov

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4