explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uE3E

Settings
# exclusive inclusive rows x rows loops node
1. 1,410.559 29,012.466 ↑ 521.7 15 1

Gather (cost=1,000.57..2,898,068.17 rows=7,825 width=48) (actual time=26,227.459..29,012.466 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.025 27,601.907 ↑ 652.0 5 3 / 3

Nested Loop (cost=0.57..2,896,274.26 rows=3,260 width=48) (actual time=26,215.080..27,601.907 rows=5 loops=3)

3. 27,601.757 27,601.757 ↑ 659.0 5 3 / 3

Parallel Seq Scan on composite_key_syn_observation (cost=0.00..2,868,102.25 rows=3,295 width=58) (actual time=26,214.992..27,601.757 rows=5 loops=3)

  • Filter: ((composite_key ? 'nifi_compound_lot_vials_liquids_di_4'::text) AND (((composite_key -> 'nifi_compound_lot_vials_liquids_di_4'::text))::bigint = ANY ('{7349921,7347938,7342151,7345621,7348678,7344883,7342603,7348796,7350016,7350027,7348271,7345818,7345203,7343513,7345829}'::bigint[])))
  • Rows Removed by Filter: 34,381,773
4. 0.125 0.125 ↑ 1.0 1 15 / 3

Index Scan using nk_mapping_syn_observation_unq_idx on nk_mapping_syn_observation (cost=0.57..8.54 rows=1 width=24) (actual time=0.025..0.025 rows=1 loops=15)

  • Index Cond: (composite_key_id = composite_key_syn_observation.id)
Planning time : 1.969 ms
Execution time : 29,012.556 ms