explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Pp

Settings
# exclusive inclusive rows x rows loops node
1. 0.871 2,702.942 ↑ 1.0 119 1

Sort (cost=1,620,942.47..1,620,942.77 rows=119 width=158) (actual time=2,702.934..2,702.942 rows=119 loops=1)

  • Sort Key: project_floorplan.name
  • Sort Method: quicksort Memory: 56kB
2. 22.762 2,702.071 ↑ 1.0 119 1

GroupAggregate (cost=1,616,473.39..1,620,938.37 rows=119 width=158) (actual time=2,656.001..2,702.071 rows=119 loops=1)

  • Group Key: project_floorplan.id, ((SubPlan 1)), ((SubPlan 2))
3. 137.872 2,679.309 ↓ 1.3 69,639 1

Sort (cost=1,616,473.39..1,616,602.78 rows=51,755 width=162) (actual time=2,655.835..2,679.309 rows=69,639 loops=1)

  • Sort Key: project_floorplan.id, ((SubPlan 1)), ((SubPlan 2))
  • Sort Method: external merge Disk: 10856kB
4. 152.119 2,541.437 ↓ 1.3 69,639 1

Hash Left Join (cost=47.03..1,608,172.13 rows=51,755 width=162) (actual time=1.453..2,541.437 rows=69,639 loops=1)

  • Hash Cond: (project_walkthroughnode.id = project_annotation.node_id)
5. 60.829 91.171 ↓ 1.3 69,634 1

Hash Right Join (cost=43.81..4,238.68 rows=51,755 width=146) (actual time=1.239..91.171 rows=69,634 loops=1)

  • Hash Cond: (project_walkthroughnode.walkthrough_id = project_walkthrough.id)
6. 29.127 29.127 ↑ 1.0 91,732 1

Seq Scan on project_walkthroughnode (cost=0.00..3,333.32 rows=91,732 width=20) (actual time=0.009..29.127 rows=91,732 loops=1)

7. 0.310 1.215 ↓ 1.6 496 1

Hash (cost=39.91..39.91 rows=312 width=134) (actual time=1.215..1.215 rows=496 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
8. 0.175 0.905 ↓ 1.6 496 1

Hash Left Join (cost=14.59..39.91 rows=312 width=134) (actual time=0.297..0.905 rows=496 loops=1)

  • Hash Cond: (project_floorplan.id = project_gpswalkthrough.floorplan_id)
9. 0.259 0.653 ↓ 1.4 441 1

Hash Right Join (cost=10.18..31.20 rows=312 width=130) (actual time=0.207..0.653 rows=441 loops=1)

  • Hash Cond: (project_walkthrough.floorplan_id = project_floorplan.id)
10. 0.206 0.206 ↑ 1.0 553 1

Seq Scan on project_walkthrough (cost=0.00..19.53 rows=553 width=8) (actual time=0.004..0.206 rows=553 loops=1)

11. 0.064 0.188 ↑ 1.0 119 1

Hash (cost=8.69..8.69 rows=119 width=126) (actual time=0.188..0.188 rows=119 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
12. 0.124 0.124 ↑ 1.0 119 1

Seq Scan on project_floorplan (cost=0.00..8.69 rows=119 width=126) (actual time=0.016..0.124 rows=119 loops=1)

  • Filter: (project_id = ANY ('{2,5,13,14,15,17}'::integer[]))
  • Rows Removed by Filter: 92
13. 0.031 0.077 ↓ 1.0 109 1

Hash (cost=3.07..3.07 rows=107 width=8) (actual time=0.077..0.077 rows=109 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
14. 0.046 0.046 ↓ 1.0 109 1

Seq Scan on project_gpswalkthrough (cost=0.00..3.07 rows=107 width=8) (actual time=0.009..0.046 rows=109 loops=1)

15. 0.027 0.060 ↑ 1.0 54 1

Hash (cost=2.54..2.54 rows=54 width=32) (actual time=0.060..0.060 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
16. 0.033 0.033 ↑ 1.0 54 1

Seq Scan on project_annotation (cost=0.00..2.54 rows=54 width=32) (actual time=0.011..0.033 rows=54 loops=1)

17.          

SubPlan (forHash Left Join)

18. 69.639 1,253.502 ↑ 1.0 1 69,639

Limit (cost=15.46..15.46 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=69,639)

19. 417.834 1,183.863 ↑ 6.0 1 69,639

Sort (cost=15.46..15.48 rows=6 width=8) (actual time=0.017..0.017 rows=1 loops=69,639)

  • Sort Key: u0.created DESC
  • Sort Method: quicksort Memory: 25kB
20. 487.473 766.029 ↓ 1.5 9 69,639

Bitmap Heap Scan on project_walkthrough u0 (cost=4.32..15.43 rows=6 width=8) (actual time=0.006..0.011 rows=9 loops=69,639)

  • Recheck Cond: (floorplan_id = project_floorplan.id)
  • Filter: show
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=341544
21. 278.556 278.556 ↓ 1.5 9 69,639

Bitmap Index Scan on project_walkthrough_floorplan_id_77ac8a9e (cost=0.00..4.32 rows=6 width=0) (actual time=0.004..0.004 rows=9 loops=69,639)

  • Index Cond: (floorplan_id = project_floorplan.id)
22. 278.556 1,044.585 ↑ 6.0 1 69,639

GroupAggregate (cost=4.32..15.52 rows=6 width=12) (actual time=0.015..0.015 rows=1 loops=69,639)

  • Group Key: u0_1.floorplan_id
23. 557.112 766.029 ↓ 1.5 9 69,639

Bitmap Heap Scan on project_walkthrough u0_1 (cost=4.32..15.43 rows=6 width=4) (actual time=0.006..0.011 rows=9 loops=69,639)

  • Recheck Cond: (floorplan_id = project_floorplan.id)
  • Filter: show
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=341544
24. 208.917 208.917 ↓ 1.5 9 69,639

Bitmap Index Scan on project_walkthrough_floorplan_id_77ac8a9e (cost=0.00..4.32 rows=6 width=0) (actual time=0.003..0.003 rows=9 loops=69,639)

  • Index Cond: (floorplan_id = project_floorplan.id)