explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VNDj

Settings
# exclusive inclusive rows x rows loops node
1. 45.503 12,650.169 ↑ 965.2 547 1

Gather (cost=36,342.10..405,481.61 rows=527,973 width=16) (actual time=4,459.953..12,650.169 rows=547 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 60.135 12,604.666 ↑ 1,208.7 182 3

Hash Left Join (cost=35,342.10..351,684.31 rows=219,989 width=16) (actual time=4,456.824..12,604.666 rows=182 loops=3)

  • Hash Cond: (b.observed_item_id_mapping_id = c.id)
  • Filter: ((c.* IS NULL) OR (yo.composite_key_id <> c.composite_key_id))
  • Rows Removed by Filter: 27825
3. 365.675 9,079.917 ↑ 7.9 28,008 3

Nested Loop Left Join (cost=334.56..316,099.29 rows=219,989 width=16) (actual time=27.663..9,079.917 rows=28,008 loops=3)

4. 4,570.879 8,714.234 ↑ 7.9 28,008 3

Hash Join (cost=334.00..171,743.08 rows=219,989 width=16) (actual time=27.607..8,714.234 rows=28,008 loops=3)

  • Hash Cond: ((a.alias = yo.key) AND (a.value = yo.val))
5. 4,116.331 4,116.331 ↑ 1.3 3,376,419 3

Parallel Seq Scan on syn_observation_observed_item_id_ref a (cost=0.00..137,461.82 rows=4,232,982 width=35) (actual time=0.009..4,116.331 rows=3,376,419 loops=3)

6. 14.049 27.024 ↑ 1.0 10,000 3

Hash (cost=184.00..184.00 rows=10,000 width=35) (actual time=27.022..27.024 rows=10,000 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 784kB
7. 12.975 12.975 ↑ 1.0 10,000 3

Seq Scan on composite_key_components yo (cost=0.00..184.00 rows=10,000 width=35) (actual time=0.022..12.975 rows=10,000 loops=3)

8. 0.008 0.008 ↑ 1.0 1 84,023

Index Only Scan using nk_mapping_syn_observation_unq_idx on nk_mapping_syn_observation b (cost=0.56..0.65 rows=1 width=16) (actual time=0.007..0.008 rows=1 loops=84,023)

  • Index Cond: (composite_key_id = a.composite_key_id)
  • Heap Fetches: 28090
9. 1,764.327 3,464.614 ↑ 1.0 1,212,513 3

Hash (cost=19,851.13..19,851.13 rows=1,212,513 width=72) (actual time=3,464.613..3,464.614 rows=1,212,513 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 126505kB
10. 1,700.287 1,700.287 ↑ 1.0 1,212,513 3

Seq Scan on nk_mapping_syn_compound c (cost=0.00..19,851.13 rows=1,212,513 width=72) (actual time=0.047..1,700.287 rows=1,212,513 loops=3)

Planning time : 0.651 ms
Execution time : 12,657.378 ms