explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hhbU

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 325.181 ↓ 200.0 200 1

Limit (cost=1,829.16..1,829.17 rows=1 width=1,166) (actual time=325.137..325.181 rows=200 loops=1)

  • Output: customer_order.order_number, customer_order.crm_order_id, customer_order.account_ucid, customer_order.order_source, customer_order.order_status, (to_char(customer_order.order_submission_date, 'YYYY-MM-DD HH24:MI:SS.MS'::text)), customer_order.ac
  • Buffers: shared hit=74016
2. 27.568 325.161 ↓ 200.0 200 1

Sort (cost=1,829.16..1,829.17 rows=1 width=1,166) (actual time=325.136..325.161 rows=200 loops=1)

  • Output: customer_order.order_number, customer_order.crm_order_id, customer_order.account_ucid, customer_order.order_source, customer_order.order_status, (to_char(customer_order.order_submission_date, 'YYYY-MM-DD HH24:MI:SS.MS'::text)), customer_or
  • Sort Key: (to_char(customer_order.order_submission_date, 'YYYY-MM-DD HH24:MI:SS.MS'::text)) DESC
  • Sort Method: top-N heapsort Memory: 674kB
  • Buffers: shared hit=74016
3. 27.831 297.593 ↓ 22,566.0 22,566 1

Nested Loop (cost=6.56..1,829.15 rows=1 width=1,166) (actual time=0.164..297.593 rows=22,566 loops=1)

  • Output: customer_order.order_number, customer_order.crm_order_id, customer_order.account_ucid, customer_order.order_source, customer_order.order_status, to_char(customer_order.order_submission_date, 'YYYY-MM-DD HH24:MI:SS.MS'::text), custome
  • Buffers: shared hit=74016
4. 0.038 0.038 ↓ 3.5 7 1

Index Scan using account_organization_id_idx on terminal.account (cost=0.42..12.45 rows=2 width=6) (actual time=0.019..0.038 rows=7 loops=1)

  • Output: account.account_ucid, account.account_sfdc_id, account.account_number, account.account_name, account.account_customer_alias, account.account_equinix_alias, account.account_type, account.account_status, account.organization_id,
  • Index Cond: (account.organization_id = 7033)
  • Buffers: shared hit=10
5. 251.132 269.724 ↓ 3,224.0 3,224 7

Bitmap Heap Scan on terminal.customer_order (cost=6.14..908.34 rows=1 width=1,142) (actual time=4.642..38.532 rows=3,224 loops=7)

  • Output: customer_order.order_number, customer_order.crm_order_id, customer_order.order_reviewed_date, customer_order.order_comments, customer_order.order_status, customer_order.order_quote_id, customer_order.order_source, customer_orde
  • Recheck Cond: (customer_order.account_number = account.account_number)
  • Filter: ((customer_order.order_submission_date >= '2018-02-06 00:00:00'::timestamp without time zone) AND (customer_order.order_submission_date <= '2019-02-07 00:00:00'::timestamp without time zone) AND (((customer_order.contact_info I
  • Rows Removed by Filter: 8455
  • Heap Blocks: exact=73760
  • Buffers: shared hit=74006
6. 18.592 18.592 ↓ 51.2 11,680 7

Bitmap Index Scan on customer_order_account_number_idx (cost=0.00..6.14 rows=228 width=0) (actual time=2.656..2.656 rows=11,680 loops=7)

  • Index Cond: (customer_order.account_number = account.account_number)
  • Buffers: shared hit=246