explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rTNv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 78.9 195,185 1

HashAggregate (cost=260.97..298.10 rows=2,475 width=120) (actual rows=195,185 loops=1)

  • Group Key: pgss.dbid, pg_wait_sampling_get_profile.event_type, pg_wait_sampling_get_profile.event, pg_wait_sampling_get_profile.queryid
  • Buffers: temp read=207,718 written=207,761
2. 0.000 0.000 ↓ 30,309.4 75,015,797 1

Merge Left Join (cost=138.46..230.03 rows=2,475 width=84) (actual rows=75,015,797 loops=1)

  • Merge Cond: (pg_wait_sampling_get_profile.queryid = pgss.queryid)
  • Filter: (NOT (hashed SubPlan 1))
  • Buffers: temp read=207,718 written=207,761
3. 0.000 0.000 ↓ 17,238.7 17,066,287 1

Sort (cost=59.26..61.74 rows=990 width=80) (actual rows=17,066,287 loops=1)

  • Sort Key: pg_wait_sampling_get_profile.queryid
  • Sort Method: external merge Disk: 824,496kB
  • Buffers: temp read=207,718 written=207,761
4. 0.000 0.000 ↓ 17,238.7 17,066,287 1

Function Scan on pg_wait_sampling_get_profile (cost=0.00..10.00 rows=990 width=80) (actual rows=17,066,287 loops=1)

  • Filter: ((event_type IS NOT NULL) AND (event IS NOT NULL))
  • Buffers: temp read=104,656 written=104,655
5. 0.000 0.000 ↓ 71,912.5 71,912,517 1

Sort (cost=59.83..62.33 rows=1,000 width=12) (actual rows=71,912,517 loops=1)

  • Sort Key: pgss.queryid
  • Sort Method: quicksort Memory: 1,045kB
6. 0.000 0.000 ↓ 14.1 14,082 1

Function Scan on pg_stat_statements pgss (cost=0.00..10.00 rows=1,000 width=12) (actual rows=14,082 loops=1)

7.          

SubPlan (for Merge Left Join)

8. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on powa_databases (cost=0.00..17.50 rows=746 width=4) (actual rows=0 loops=1)

  • Filter: (dropped IS NOT NULL)