#	exclusive	inclusive	rows x	rows	loops	node
1.	0.033	3,208.595	↑ 1.0	1	1	→ Aggregate (cost=360,126.59..360,126.60 rows=1 width=8) (actual time=3,208.595..3,208.595 rows=1 loops=1)
2.	0.478	3,208.562	↓ 2.9	61	1	→ Nested Loop (cost=169,064.86..360,126.54 rows=21 width=0) (actual time=2,657.788..3,208.562 rows=61 loops=1)
3.	198.877	3,202.108	↓ 4.7	747	1	→ Hash Join (cost=169,064.29..359,694.40 rows=158 width=4) (actual time=2,657.772..3,202.108 rows=747 loops=1) Hash Cond: (oms_restaurantdetails.id = oms_order.restaurant_details_id)
4.	345.774	345.774	↓ 1.7	295,631	1	→ Index Scan using oms_restaurantdetails_d266de13 on oms_restaurantdetails (cost=0.57..188,072.04 rows=172,853 width=4) (actual time=0.035..345.774 rows=295,631 loops=1) Index Cond: (area_id = 253)
5.	181.554	2,657.457	↓ 2.7	386,494	1	→ Hash (cost=166,724.85..166,724.85 rows=142,550 width=8) (actual time=2,657.457..2,657.457 rows=386,494 loops=1) Buckets: 32768 (originally 32768) Batches: 32 (originally 8) Memory Usage: 793kB
6.	2,475.903	2,475.903	↓ 2.7	386,494	1	→ Index Scan using ordered_time_desc_idx on oms_order (cost=0.57..166,724.85 rows=142,550 width=8) (actual time=0.022..2,475.903 rows=386,494 loops=1) Index Cond: (ordered_time >= '2018-12-02 05:18:06.080237+00'::timestamp with time zone) Filter: (((payment_txn_status)::text <> ALL ('{failed,pending}'::text[])) OR (payment_txn_status IS NULL)) Rows Removed by Filter: 59387
7.	5.976	5.976	↓ 0.0	0	747	→ Index Scan using oms_orderstatus_pkey on oms_orderstatus (cost=0.57..2.73 rows=1 width=4) (actual time=0.007..0.008 rows=0 loops=747) Index Cond: (id = oms_order.status_id) Filter: ((order_status)::text <> ALL ('{delivered,cancelled}'::text[])) Rows Removed by Filter: 1

 Aggregate  (cost=360126.59..360126.60 rows=1 width=8) (actual time=3208.595..3208.595 rows=1 loops=1)
   ->  Nested Loop  (cost=169064.86..360126.54 rows=21 width=0) (actual time=2657.788..3208.562 rows=61 loops=1)
         ->  Hash Join  (cost=169064.29..359694.40 rows=158 width=4) (actual time=2657.772..3202.108 rows=747 loops=1)
               Hash Cond: (oms_restaurantdetails.id = oms_order.restaurant_details_id)
               ->  Index Scan using oms_restaurantdetails_d266de13 on oms_restaurantdetails  (cost=0.57..188072.04 rows=172853 width=4) (actual time=0.035..345.774 rows=295631 loops=1)
                     Index Cond: (area_id = 253)
               ->  Hash  (cost=166724.85..166724.85 rows=142550 width=8) (actual time=2657.457..2657.457 rows=386494 loops=1)
                     Buckets: 32768 (originally 32768)  Batches: 32 (originally 8)  Memory Usage: 793kB
                     ->  Index Scan using ordered_time_desc_idx on oms_order  (cost=0.57..166724.85 rows=142550 width=8) (actual time=0.022..2475.903 rows=386494 loops=1)
                           Index Cond: (ordered_time >= '2018-12-02 05:18:06.080237+00'::timestamp with time zone)
                           Filter: (((payment_txn_status)::text <> ALL ('{failed,pending}'::text[])) OR (payment_txn_status IS NULL))
                           Rows Removed by Filter: 59387
         ->  Index Scan using oms_orderstatus_pkey on oms_orderstatus  (cost=0.57..2.73 rows=1 width=4) (actual time=0.007..0.008 rows=0 loops=747)
               Index Cond: (id = oms_order.status_id)
               Filter: ((order_status)::text <> ALL ('{delivered,cancelled}'::text[]))
               Rows Removed by Filter: 1
 Planning time: 0.597 ms
 Execution time: 3208.675 ms
(18 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.033 ms	0.0 %
Hash	1	181.554 ms	5.7 %
Hash Join	1	198.877 ms	6.2 %
Index Scan	3	2,827.653 ms	88.1 %
Nested Loop	1	0.478 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
oms_order	1	2,475.903 ms	77.2 %
Index Scan	1	2,475.903 ms	100.0 %
oms_orderstatus	1	5.976 ms	0.2 %
Index Scan	1	5.976 ms	100.0 %
oms_restaurantdetails	1	345.774 ms	10.8 %
Index Scan	1	345.774 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wL6g

Color mode:

Visible columns:

Per node type stats

Per table stats