explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sx98

Settings
# exclusive inclusive rows x rows loops node
1. 0.183 100.903 ↑ 32.7 50 1

Hash Join (cost=9,939.46..10,017.17 rows=1,636 width=321) (actual time=100.694..100.903 rows=50 loops=1)

  • Hash Cond: ((max(processes_1.process_id)) = processes.process_id)
2. 0.049 64.463 ↑ 32.7 50 1

Unique (cost=5,444.78..5,473.41 rows=1,636 width=305) (actual time=64.391..64.463 rows=50 loops=1)

3. 0.690 64.414 ↑ 32.7 50 1

Sort (cost=5,444.78..5,448.87 rows=1,636 width=305) (actual time=64.388..64.414 rows=50 loops=1)

  • Sort Key: pipeline_stage.display_name, pipelines.display_name, pipelines.pipeline_id, (count(pipelines.pipeline_id)), (max(processes_1.process_id)), pipelines.pipeline_stage_id
  • Sort Method: quicksort Memory: 31kB
4. 2.786 63.724 ↑ 32.7 50 1

HashAggregate (cost=5,341.09..5,357.45 rows=1,636 width=305) (actual time=63.681..63.724 rows=50 loops=1)

  • Group Key: pipelines.pipeline_id, pipeline_stage.pipeline_stage_id
5. 2.902 60.938 ↓ 1.5 2,518 1

Hash Join (cost=4,894.72..5,324.73 rows=1,636 width=305) (actual time=35.635..60.938 rows=2,518 loops=1)

  • Hash Cond: (process_fields.field_id = fields.field_id)
6. 12.780 57.944 ↓ 1.5 2,518 1

Hash Join (cost=4,887.46..5,294.97 rows=1,636 width=309) (actual time=35.511..57.944 rows=2,518 loops=1)

  • Hash Cond: (process_fields.process_id = processes_1.process_id)
7. 9.704 9.704 ↓ 1.0 19,890 1

Seq Scan on process_fields (cost=0.00..318.02 rows=19,502 width=8) (actual time=0.006..9.704 rows=19,890 loops=1)

8. 1.625 35.460 ↓ 1.4 1,568 1

Hash (cost=4,873.63..4,873.63 rows=1,106 width=309) (actual time=35.460..35.460 rows=1,568 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 126kB
9. 2.161 33.835 ↓ 1.4 1,568 1

Hash Join (cost=4,621.42..4,873.63 rows=1,106 width=309) (actual time=20.118..33.835 rows=1,568 loops=1)

  • Hash Cond: (process_pipeline.pipeline_id = pipelines.pipeline_id)
10. 6.936 31.089 ↓ 1.0 1,761 1

Hash Join (cost=4,396.24..4,631.04 rows=1,695 width=12) (actual time=19.511..31.089 rows=1,761 loops=1)

  • Hash Cond: (process_pipeline.process_id = processes_1.process_id)
11. 4.711 4.711 ↓ 1.0 8,725 1

Seq Scan on process_pipeline (cost=0.00..165.60 rows=8,360 width=8) (actual time=0.010..4.711 rows=8,725 loops=1)

12. 2.481 19.442 ↓ 1.2 3,144 1

Hash (cost=4,362.82..4,362.82 rows=2,673 width=4) (actual time=19.442..19.442 rows=3,144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 111kB
13. 16.961 16.961 ↓ 1.2 3,144 1

Seq Scan on processes processes_1 (cost=0.00..4,362.82 rows=2,673 width=4) (actual time=0.019..16.961 rows=3,144 loops=1)

  • Filter: ((NOT flag_removed) AND ((instance)::text = 'testing'::text))
  • Rows Removed by Filter: 10068
14. 0.085 0.585 ↑ 1.0 77 1

Hash (cost=224.22..224.22 rows=77 width=301) (actual time=0.585..0.585 rows=77 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
15. 0.151 0.500 ↑ 1.0 77 1

Hash Join (cost=13.82..224.22 rows=77 width=301) (actual time=0.056..0.500 rows=77 loops=1)

  • Hash Cond: (pipelines.pipeline_stage_id = pipeline_stage.pipeline_stage_id)
16. 0.330 0.330 ↑ 1.0 118 1

Seq Scan on pipelines (cost=0.00..209.18 rows=118 width=23) (actual time=0.007..0.330 rows=118 loops=1)

17. 0.008 0.019 ↑ 24.3 7 1

Hash (cost=11.70..11.70 rows=170 width=278) (actual time=0.019..0.019 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
18. 0.011 0.011 ↑ 24.3 7 1

Seq Scan on pipeline_stage (cost=0.00..11.70 rows=170 width=278) (actual time=0.007..0.011 rows=7 loops=1)

19. 0.038 0.092 ↑ 1.0 54 1

Hash (cost=6.56..6.56 rows=56 width=4) (actual time=0.092..0.092 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
20. 0.054 0.054 ↑ 1.0 54 1

Seq Scan on fields (cost=0.00..6.56 rows=56 width=4) (actual time=0.010..0.054 rows=54 loops=1)

21. 14.190 36.257 ↓ 1.0 13,212 1

Hash (cost=4,329.86..4,329.86 rows=13,186 width=20) (actual time=36.257..36.257 rows=13,212 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 657kB
22. 22.067 22.067 ↓ 1.0 13,212 1

Seq Scan on processes (cost=0.00..4,329.86 rows=13,186 width=20) (actual time=0.012..22.067 rows=13,212 loops=1)