explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hzb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 144.510 ↑ 1.3 13,965 1

Gather Merge (cost=241,394.04..243,578.19 rows=18,720 width=376) (actual time=106.045..144.510 rows=13,965 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 62.757 309.900 ↑ 2.0 4,655 3

Sort (cost=240,394.02..240,417.42 rows=9,360 width=376) (actual time=100.914..103.300 rows=4,655 loops=3)

  • Sort Key: tdms_coreur_core_urs.urid, tdms_coremd_metadata.coremd_id, tdms_corefl_core_files.corefl_id
  • Sort Method: quicksort Memory: 2490kB
3. 26.886 247.143 ↑ 2.0 4,655 3

Nested Loop Left Join (cost=1.56..239,776.62 rows=9,360 width=376) (actual time=15.449..82.381 rows=4,655 loops=3)

4. 15.265 164.397 ↓ 1.3 4,655 3

Nested Loop Left Join (cost=1.12..198,443.83 rows=3,712 width=322) (actual time=15.434..54.799 rows=4,655 loops=3)

5. 130.512 130.512 ↓ 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=15.413..43.504 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. 18.620 18.620 ↑ 1,916.5 15 931

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.012..0.020 rows=15 loops=931)

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

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

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)
Planning time : 1.923 ms
Execution time : 149.868 ms