explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dutM

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1,193.888 ↑ 2.1 14 1

Sort (cost=132,289.87..132,289.94 rows=30 width=636) (actual time=1,193.883..1,193.888 rows=14 loops=1)

  • Sort Key: regions.c_order
  • Sort Method: quicksort Memory: 28kB
  • Functions: 25
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 6.403 ms, Inlining 0.000 ms, Optimization 1.392 ms, Emission 20.856 ms, Total 28.651 ms
2. 186.448 1,193.873 ↑ 2.1 14 1

HashAggregate (cost=132,288.83..132,289.13 rows=30 width=636) (actual time=1,193.864..1,193.873 rows=14 loops=1)

  • Group Key: regions.id
3. 112.341 1,007.425 ↓ 1.2 670,243 1

Hash Right Join (cost=33,318.77..91,536.09 rows=582,182 width=708) (actual time=237.965..1,007.425 rows=670,243 loops=1)

  • Hash Cond: (families.region_id = regions.id)
4. 352.714 872.500 ↓ 1.2 670,243 1

Hash Right Join (cost=33,308.10..89,781.30 rows=582,182 width=188) (actual time=215.373..872.500 rows=670,243 loops=1)

  • Hash Cond: (poors.family_id = families.id)
5. 308.392 308.392 ↓ 1.0 483,869 1

Seq Scan on poors (cost=0.00..27,280.85 rows=475,940 width=188) (actual time=0.028..308.392 rows=483,869 loops=1)

  • Filter: (created_at < '2020-09-08 01:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1,651
6. 109.264 211.394 ↓ 1.0 582,201 1

Hash (cost=23,187.82..23,187.82 rows=582,182 width=12) (actual time=211.394..211.394 rows=582,201 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 21,845kB
7. 102.130 102.130 ↓ 1.0 582,201 1

Seq Scan on families (cost=0.00..23,187.82 rows=582,182 width=12) (actual time=0.015..102.130 rows=582,201 loops=1)

8. 0.010 22.584 ↑ 2.1 14 1

Hash (cost=10.30..10.30 rows=30 width=524) (actual time=22.584..22.584 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 22.574 22.574 ↑ 2.1 14 1

Seq Scan on regions (cost=0.00..10.30 rows=30 width=524) (actual time=22.569..22.574 rows=14 loops=1)

Planning time : 0.800 ms
Execution time : 1,201.722 ms