explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OPrM

Settings
# exclusive inclusive rows x rows loops node
1. 1,136.633 23,706.263 ↑ 1.2 194 1

Unique (cost=304,429.90..308,223.04 rows=239 width=25) (actual time=19,807.040..23,706.263 rows=194 loops=1)

2. 11,797.230 22,569.630 ↓ 2.0 1,492,482 1

Sort (cost=304,429.90..306,326.47 rows=758,628 width=25) (actual time=19,807.035..22,569.630 rows=1,492,482 loops=1)

  • Sort Key: s.input_form
  • Sort Method: external merge Disk: 45432kB
3. 4,972.924 10,772.400 ↓ 2.0 1,492,482 1

Hash Join (cost=19.83..212,187.37 rows=758,628 width=25) (actual time=0.449..10,772.400 rows=1,492,482 loops=1)

  • Hash Cond: (s.survey_id = su.id)
4. 5,799.083 5,799.083 ↑ 1.0 4,297,126 1

Seq Scan on samples s (cost=0.00..188,424.64 rows=4,308,434 width=21) (actual time=0.024..5,799.083 rows=4,297,126 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 38672
5. 0.107 0.393 ↑ 1.0 102 1

Hash (cost=18.50..18.50 rows=106 width=8) (actual time=0.393..0.393 rows=102 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
6. 0.204 0.286 ↑ 1.0 102 1

Bitmap Heap Scan on surveys su (cost=5.13..18.50 rows=106 width=8) (actual time=0.094..0.286 rows=102 loops=1)

  • Recheck Cond: (website_id = 23)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 1
7. 0.082 0.082 ↑ 1.1 103 1

Bitmap Index Scan on fki_survey_website (cost=0.00..5.10 rows=110 width=0) (actual time=0.082..0.082 rows=103 loops=1)

  • Index Cond: (website_id = 23)