explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mk6V

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Merge (cost=590,965.18..591,068.68 rows=900 width=372) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Sort (cost=589,965.17..589,967.42 rows=900 width=372) (actual rows= loops=)

  • Sort Key: tdms_coreur_core_urs.urid, tdms_coremd_metadata.coremd_id, tdms_corefl_core_files.corefl_id
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..589,921.01 rows=900 width=372) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.99..54,003.26 rows=29 width=241) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Index Scan using idms_coreur_prod_core_uk on tdms_coreur_core_urs (cost=0.56..53,707.48 rows=29 width=192) (actual rows= loops=)

  • Index Cond: (product_id = '-8684834592658538181'::bigint)
  • Filter: ((effectivity_start_iet < '1953483381982180'::bigint) AND (effectivity_stop_iet > '1953483381982180'::bigint) AND (archive_state <> ALL ('{A,D,F}'::bpchar[])))
6. 0.000 0.000 ↓ 0.0

Index Scan using idms_corefl_coreur_fk on tdms_corefl_core_files (cost=0.43..10.17 rows=3 width=49) (actual rows= loops=)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using idms_coremd_coreur_fk on tdms_coremd_metadata (cost=0.57..18,358.92 rows=12,100 width=131) (actual rows= loops=)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)