explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ONJg : offset pag

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

Limit (cost=130.49..260.00 rows=50 width=82) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.99..47,605.72 rows=18,380 width=82) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..47,330.02 rows=18,380 width=66) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..13,385.00 rows=18,461 width=22) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on md_max_result (cost=0.00..55.68 rows=1 width=5) (actual rows= loops=)

  • Filter: (business_date = '2019-05-01'::date)
6. 0.000 0.000 ↓ 0.0

Index Scan using idx11_md_res_det on md_result_details (cost=0.57..13,144.16 rows=18,516 width=27) (actual rows= loops=)

  • Index Cond: ((result_id = md_max_result.max_result_id) AND ((country_cd)::text = 'US'::text))
7. 0.000 0.000 ↓ 0.0

Index Scan using "MD_SECURITY_PK_MD_SECURITY" on md_security (cost=0.42..1.84 rows=1 width=56) (actual rows= loops=)

  • Index Cond: (md_security_id = md_result_details.md_security_id)