explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lINB

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 0.061 ↓ 0.0 0 1

CTE Scan on cte_dual (cost=68.92..69.04 rows=6 width=110) (actual time=0.061..0.061 rows=0 loops=1)

2.          

CTE cte_dual

3. 0.000 0.060 ↓ 0.0 0 1

Unique (cost=68.86..68.92 rows=6 width=88) (actual time=0.060..0.060 rows=0 loops=1)

4. 0.004 0.060 ↓ 0.0 0 1

Sort (cost=68.86..68.88 rows=6 width=88) (actual time=0.060..0.060 rows=0 loops=1)

  • Sort Key: a.client_id, a.start_date_id, a.end_date_id
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.056 ↓ 0.0 0 1

Nested Loop Left Join (cost=36.10..68.79 rows=6 width=88) (actual time=0.056..0.056 rows=0 loops=1)

  • Filter: ((rpt_bldr_data_load_status_1.start_date_id IS NULL) OR ((rpt_bldr_data_load_status_1.last_load_time IS NOT NULL) AND (rpt_bldr_data_load_status_1.last_load_time < a.last_load_time)))
6. 0.005 0.056 ↓ 0.0 0 1

Hash Right Join (cost=35.82..59.23 rows=18 width=28) (actual time=0.056..0.056 rows=0 loops=1)

  • Hash Cond: (rpt_bldr_data_load_status.client_id = a.client_id)
  • Filter: ((((da_settings.property_value)::text = 'C'::text) AND (rpt_bldr_data_load_status.end_date_id IS NOT NULL) AND ((to_date((rpt_bldr_data_load_status.end_date_id)::text, 'YYYYMMDD'::text) - 1) <= to_date((a.start_date_id)::text, 'YYYYMMDD'::text))) OR (((da_settings_1.property_value)::text = 'Y'::text) AND (da_settings.property_value IS NULL)))
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on rpt_bldr_data_load_status (cost=0.00..23.29 rows=1 width=13) (never executed)

  • Filter: (((input_source)::text = 'REGHISTM'::text) AND ((status)::text = 'C'::text))
8. 0.000 0.051 ↓ 0.0 0 1

Hash (cost=35.17..35.17 rows=52 width=66) (actual time=0.051..0.051 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.000 0.051 ↓ 0.0 0 1

Nested Loop (cost=23.72..35.17 rows=52 width=66) (actual time=0.051..0.051 rows=0 loops=1)

10. 0.001 0.051 ↓ 0.0 0 1

Unique (cost=10.91..10.93 rows=1 width=43) (actual time=0.051..0.051 rows=0 loops=1)

11. 0.003 0.050 ↓ 0.0 0 1

Sort (cost=10.91..10.92 rows=1 width=43) (actual time=0.050..0.050 rows=0 loops=1)

  • Sort Key: da.client_id, da_settings.property_value, da_settings_1.property_value
  • Sort Method: quicksort Memory: 25kB
12. 0.007 0.047 ↓ 0.0 0 1

Hash Left Join (cost=7.20..10.90 rows=1 width=43) (actual time=0.047..0.047 rows=0 loops=1)

  • Hash Cond: (da.client_id = da_settings_1.client_id)
  • Filter: (((da_settings.property_value)::text = 'C'::text) OR (((da_settings_1.property_value)::text = 'Y'::text) AND (da_settings.property_value IS NULL)))
  • Rows Removed by Filter: 17
13. 0.008 0.032 ↑ 1.0 17 1

Hash Left Join (cost=3.60..7.24 rows=17 width=24) (actual time=0.021..0.032 rows=17 loops=1)

  • Hash Cond: (da.client_id = da_settings.client_id)
14. 0.012 0.012 ↑ 1.0 17 1

Seq Scan on da_settings da (cost=0.00..3.59 rows=17 width=5) (actual time=0.004..0.012 rows=17 loops=1)

  • Filter: ((property_name)::text = 'REPORT_BUILDER_QUERY_CLUSTER_ID'::text)
  • Rows Removed by Filter: 110
15. 0.000 0.012 ↓ 0.0 0 1

Hash (cost=3.59..3.59 rows=1 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on da_settings (cost=0.00..3.59 rows=1 width=24) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((property_name)::text = 'REGISTRATION_HISTORY_ORC_MIGRATION'::text)
  • Rows Removed by Filter: 127
17. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=3.59..3.59 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
18. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on da_settings da_settings_1 (cost=0.00..3.59 rows=1 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((property_name)::text = 'DDR_QUERY_PROCESSING_ENABLED'::text)
  • Rows Removed by Filter: 127
19. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on rpt_bldr_data_load_status a (cost=12.81..23.72 rows=52 width=28) (never executed)

  • Recheck Cond: ((client_id = da.client_id) AND ((input_source)::text = 'REGACT2'::text))
  • Filter: ((last_load_time IS NOT NULL) AND ((status)::text = 'C'::text))
20. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on rbdls_comp_idx (cost=0.00..12.79 rows=52 width=0) (never executed)

  • Index Cond: ((client_id = da.client_id) AND ((input_source)::text = 'REGACT2'::text))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using rbdls_comp_idx on rpt_bldr_data_load_status rpt_bldr_data_load_status_1 (cost=0.28..0.52 rows=1 width=21) (never executed)

  • Index Cond: ((a.client_id = client_id) AND (a.start_date_id = start_date_id) AND ((input_source)::text = 'REGHIST'::text))
Planning time : 0.640 ms
Execution time : 0.127 ms