explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MGvG

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 154.501 ↑ 1.0 1 1

Subquery Scan on t (cost=14.22..14.32 rows=1 width=32) (actual time=154.500..154.501 rows=1 loops=1)

  • Buffers: shared hit=1, temp read=3,545 written=3,545
2. 5.152 154.464 ↑ 1.0 1 1

Aggregate (cost=14.22..14.30 rows=1 width=120) (actual time=154.464..154.464 rows=1 loops=1)

  • Buffers: shared hit=1, temp read=3,545 written=3,545
3. 3.991 149.312 ↓ 487.4 4,874 1

Hash Join (cost=1.08..13.76 rows=10 width=96) (actual time=123.327..149.312 rows=4,874 loops=1)

  • Hash Cond: (pg_stat_statements.dbid = pgdb.oid)
  • Buffers: shared hit=1, temp read=3,545 written=3,545
4. 145.292 145.292 ↓ 4.9 4,942 1

Function Scan on pg_stat_statements (cost=0.00..10.00 rows=1,000 width=100) (actual time=123.274..145.292 rows=4,942 loops=1)

  • Buffers: temp read=3,545 written=3,545
5. 0.004 0.029 ↑ 2.0 1 1

Hash (cost=1.05..1.05 rows=2 width=4) (actual time=0.028..0.029 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
6. 0.025 0.025 ↑ 2.0 1 1

Seq Scan on pg_database pgdb (cost=0.00..1.05 rows=2 width=4) (actual time=0.023..0.025 rows=1 loops=1)

  • Filter: ((NOT datistemplate) AND (datname <> 'postgres'::name))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
Planning time : 0.346 ms
Execution time : 177.522 ms