explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cM30 : test_pa

Settings
# exclusive inclusive rows x rows loops node
1. 1.773 1,847.258 ↑ 363.8 2,034 1

Sort (cost=2,207,745.71..2,209,595.45 rows=739,895 width=43) (actual time=1,847.167..1,847.258 rows=2,034 loops=1)

  • Sort Key: (to_char((own_etf_hist_unadjusted.report_date)::timestamp with time zone, 'yyyymmdd'::text))
  • Sort Method: quicksort Memory: 207kB
  • Buffers: shared hit=112,301
2. 421.947 1,845.485 ↑ 363.8 2,034 1

Group (cost=0.57..2,112,856.69 rows=739,895 width=43) (actual time=0.09..1,845.485 rows=2,034 loops=1)

  • Group Key: own_etf_hist_unadjusted.report_date, own_etf_hist_unadjusted.company_number
  • Buffers: shared hit=112,298
3. 1,423.538 1,423.538 ↓ 1.0 2,960,745 1

Index Only Scan using own_etf_hist_unadjusted_company_num_rep_date_idx on own_etf_hist_unadjusted own_etf_hist_unadjusted (cost=0.57..2,094,927.82 rows=2,845,879 width=11) (actual time=0.03..1,423.538 rows=2,960,745 loops=1)

  • Index Cond: (own_etf_hist_unadjusted.company_number = '4090077'::numeric)
  • Heap Fetches: 896,420
  • Buffers: shared hit=112,298
Planning time : 0.752 ms
Execution time : 1,847.445 ms