explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hXZc

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

Index Scan using index_orders_on_business_id_and_source_and_identifier on orders (cost=0.57..9,408,788.32 rows=44,109 width=251) (actual rows= loops=)

  • Index Cond: (business_id = ANY ('{528470,490024,522015,337824,121816,549333,475232,521535,521783,542014,516608,489449,306380,23851,319229,423386,543220,345962,54492,498001,482284,530515,409370,550843,510410,346747,484414,470920,500020,391103,451767,415989,225718,577425,504519,331797,444238,510693,74955,555718,91191,431416,549615,531887,545106,518181,294225,510869,541855,515248,535390,458926,182792,530700,160282,513223,495165,471135,576319,450560,481843,407747,359930,467675,530959,331373,488141,583249,572014,505565,406795,507791,327011,402378,568245,519764,440408,503566,526806,243515,543337,477561,523948,452595,556810,480168,537318,416111,161024,438727,452377,467721,496867,392011,519452,534096,381073,493218,363827,523507}'::bigint[]))
  • Filter: ((customer_id IS NOT NULL) AND ((NOT imported) OR (imported IS NULL)) AND (created_at < '2020-07-13 19:51:57'::timestamp without time zone) AND (created_at > '2020-06-23 14:47:51'::timestamp without time zone))