explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktTg

Settings
# exclusive inclusive rows x rows loops node
1. 9,282.674 30,115.053 ↑ 1.4 337,486 1

Hash Join (cost=1,131,625.36..1,786,391.53 rows=468,425 width=16) (actual time=24,083.282..30,115.053 rows=337,486 loops=1)

  • Hash Cond: (put_assignments.scan_event_id = scan_phase_groups.scan_event_id)
2. 5,549.188 5,549.188 ↑ 1.0 16,033,449 1

Seq Scan on put_assignments (cost=0.00..368,460.49 rows=16,033,449 width=32) (actual time=0.006..5,549.188 rows=16,033,449 loops=1)

3. 127.383 15,283.191 ↑ 1.4 337,561 1

Hash (cost=1,123,482.05..1,123,482.05 rows=468,425 width=16) (actual time=15,283.191..15,283.191 rows=337,561 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 2988kB
4. 5,616.231 15,155.808 ↑ 1.4 337,561 1

Hash Join (cost=480,646.39..1,123,482.05 rows=468,425 width=16) (actual time=10,052.500..15,155.808 rows=337,561 loops=1)

  • Hash Cond: (test_activations.phase_group_id = scan_phase_groups.phase_group_id)
5. 151.353 151.353 ↓ 1.0 448,288 1

Index Only Scan using test_activations_experiment_name_phase_group_id_idx on test_activations (cost=0.56..61,188.62 rows=442,886 width=16) (actual time=0.023..151.353 rows=448,288 loops=1)

  • Index Cond: (experiment_name = 'background_barcode_detection_phase_2'::text)
  • Heap Fetches: 6516
6. 5,548.663 9,388.224 ↑ 1.0 13,068,748 1

Hash (cost=227,948.48..227,948.48 rows=13,068,748 width=32) (actual time=9,388.224..9,388.224 rows=13,068,748 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 3695kB
7. 3,839.561 3,839.561 ↑ 1.0 13,068,748 1

Seq Scan on scan_phase_groups (cost=0.00..227,948.48 rows=13,068,748 width=32) (actual time=0.041..3,839.561 rows=13,068,748 loops=1)

Planning time : 0.469 ms
Execution time : 30,181.695 ms