explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ns7T

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 93.139 ↓ 16.2 14,700 1

Gather Merge (cost=616,641.74..616,746.39 rows=910 width=372) (actual time=74.581..93.139 rows=14,700 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 82.798 119.286 ↓ 8.1 7,350 2

Sort (cost=615,641.73..615,644.01 rows=910 width=372) (actual time=56.797..59.643 rows=7,350 loops=2)

  • Sort Key: tdms_coreur_core_urs.urid, tdms_coremd_metadata.coremd_id, tdms_corefl_core_files.corefl_id
  • Sort Method: external sort Disk: 2984kB
3. 11.388 36.488 ↓ 8.1 7,350 2

Nested Loop Left Join (cost=1.56..615,597.01 rows=910 width=372) (actual time=0.329..18.244 rows=7,350 loops=2)

4. 1.076 10.400 ↓ 16.3 490 2

Nested Loop Left Join (cost=0.99..55,114.52 rows=30 width=241) (actual time=0.315..5.200 rows=490 loops=2)

5. 5.404 5.404 ↓ 16.3 490 2

Parallel Index Scan using idms_coreur_prod_core_uk on tdms_coreur_core_urs (cost=0.56..54,808.54 rows=30 width=192) (actual time=0.302..2.702 rows=490 loops=2)

  • Index Cond: (product_id = '-8684834592658538181'::bigint)
  • Filter: ((effectivity_start_iet < '1953498483655699'::bigint) AND (effectivity_stop_iet > '1953498483655699'::bigint) AND (archive_state <> ALL ('{A,D,F}'::bpchar[])))
  • Rows Removed by Filter: 4
6. 3.920 3.920 ↑ 3.0 1 980

Index Scan using idms_corefl_coreur_fk on tdms_corefl_core_files (cost=0.43..10.17 rows=3 width=49) (actual time=0.003..0.004 rows=1 loops=980)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)
7. 14.700 14.700 ↑ 816.3 15 980

Index Scan using idms_coremd_coreur_fk on tdms_coremd_metadata (cost=0.57..18,560.30 rows=12,245 width=131) (actual time=0.009..0.015 rows=15 loops=980)

  • Index Cond: (tdms_coreur_core_urs.coreur_id = coreur_id)
Planning time : 0.516 ms
Execution time : 96.958 ms