explain.depesz.com

PostgreSQL's explain analyze made readable

Result: drdm

Settings
# exclusive inclusive rows x rows loops node
1. 988.687 3,465.077 ↑ 1.0 2 1

GroupAggregate (cost=416,488.47..419,810.52 rows=2 width=17) (actual time=2,672.818..3,465.077 rows=2 loops=1)

  • Group Key: survey_surveytaker.complete
2. 970.164 2,476.390 ↓ 10.7 3,544,281 1

Sort (cost=416,488.47..417,318.98 rows=332,203 width=5) (actual time=2,173.312..2,476.390 rows=3,544,281 loops=1)

  • Sort Key: survey_surveytaker.complete
  • Sort Method: external merge Disk: 62,432kB
3. 1,008.992 1,506.226 ↓ 10.7 3,544,281 1

Hash Join (cost=320,103.06..386,022.62 rows=332,203 width=5) (actual time=236.348..1,506.226 rows=3,544,281 loops=1)

  • Hash Cond: (survey_sentemployeegroup_takers.surveytaker_id = survey_surveytaker.id)
4. 262.655 262.655 ↑ 1.0 3,544,281 1

Seq Scan on temp_survey_sentemployeegroup_takers survey_sentemployeegroup_takers (cost=0.00..56,615.81 rows=3,544,281 width=4) (actual time=0.006..262.655 rows=3,544,281 loops=1)

5. 64.511 234.579 ↑ 1.0 329,633 1

Hash (cost=315,778.05..315,778.05 rows=346,001 width=5) (actual time=234.578..234.579 rows=329,633 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 16,973kB
6. 170.068 170.068 ↑ 1.0 329,633 1

Index Scan using survey_surveytaker_instance_id on survey_surveytaker (cost=0.43..315,778.05 rows=346,001 width=5) (actual time=0.035..170.068 rows=329,633 loops=1)

  • Index Cond: (instance_id = ANY ('{10288,10131,9995,9938,9828}'::integer[]))
  • Filter: ((NOT complete) OR (NOT skip_when_counting) OR (skip_when_counting IS NULL))
Planning time : 0.294 ms
Execution time : 3,474.126 ms