explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QhAc : offset pag

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 112.447 ↑ 1.0 50 1

Limit (cost=130.49..260.00 rows=50 width=82) (actual time=112.432..112.447 rows=50 loops=1)

2. 7.127 112.438 ↑ 183.8 100 1

WindowAgg (cost=0.99..47,605.72 rows=18,380 width=82) (actual time=112.418..112.438 rows=100 loops=1)

3. 13.658 105.311 ↓ 1.1 20,208 1

Nested Loop (cost=0.99..47,330.02 rows=18,380 width=66) (actual time=0.206..105.311 rows=20,208 loops=1)

4. 36.076 51.237 ↓ 1.1 20,208 1

Nested Loop (cost=0.57..13,385.00 rows=18,461 width=22) (actual time=0.201..51.237 rows=20,208 loops=1)

5. 0.196 0.196 ↑ 1.0 1 1

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

  • Filter: (business_date = '2019-05-01'::date)
  • Rows Removed by Filter: 3093
6. 14.965 14.965 ↓ 1.1 20,208 1

Index Scan using idx11_md_res_det on md_result_details (cost=0.57..13,144.16 rows=18,516 width=27) (actual time=0.019..14.965 rows=20,208 loops=1)

  • Index Cond: ((result_id = md_max_result.max_result_id) AND ((country_cd)::text = 'US'::text))
7. 40.416 40.416 ↑ 1.0 1 20,208

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

  • Index Cond: (md_security_id = md_result_details.md_security_id)
Planning time : 0.947 ms
Execution time : 112.872 ms