explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PEdh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 84.045 ↑ 1.3 13,950 1

Gather Merge (cost=241,394.04..243,578.19 rows=18,720 width=376) (actual time=57.985..84.045 rows=13,950 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 62.628 139.575 ↑ 2.0 4,650 3

Sort (cost=240,394.02..240,417.42 rows=9,360 width=376) (actual time=44.610..46.525 rows=4,650 loops=3)

  • Sort Key: tdms_coreur_core_urs.urid, tdms_coremd_metadata.coremd_id, tdms_corefl_core_files.corefl_id
  • Sort Method: quicksort Memory: 2947kB
3. 25.251 76.947 ↑ 2.0 4,650 3

Nested Loop Left Join (cost=1.56..239,776.62 rows=9,360 width=376) (actual time=0.049..25.649 rows=4,650 loops=3)

4. 11.952 23.796 ↓ 1.3 4,650 3

Nested Loop Left Join (cost=1.12..198,443.83 rows=3,712 width=322) (actual time=0.039..7.932 rows=4,650 loops=3)

5. 1.614 1.614 ↓ 23.8 310 3

Parallel Index Scan using idms_coreur_prod_core_uk on tdms_coreur_core_urs (cost=0.55..13,158.99 rows=13 width=192) (actual time=0.024..0.538 rows=310 loops=3)

  • Index Cond: (product_id = '-8684834592658538181'::bigint)
  • Filter: ((effectivity_start_iet <= '1953988130666000'::bigint) AND (effectivity_stop_iet >= '1953988130666000'::bigint) AND (dataset_lock_flag = 'F'::bpchar) AND (archive_state <> ALL ('{A,D,F}'::bpchar[])))
  • Rows Removed by Filter: 14
6. 10.230 10.230 ↑ 1,916.5 15 930

Index Scan using idms_coremd_coreur_fk on tdms_coremd_metadata (cost=0.57..13,965.21 rows=28,747 width=130) (actual time=0.005..0.011 rows=15 loops=930)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)
7. 27.900 27.900 ↑ 4.0 1 13,950

Index Scan using idms_corefl_coreur_fk on tdms_corefl_core_files (cost=0.43..11.09 rows=4 width=54) (actual time=0.002..0.002 rows=1 loops=13,950)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)