explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yUJ3 : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 912.875 ↓ 11.0 11 1

GroupAggregate (cost=34,264.86..34,264.88 rows=1 width=19) (actual time=912.831..912.875 rows=11 loops=1)

  • Group Key: vendor_list_details.vendor_code
2. 0.149 912.758 ↓ 74.0 74 1

Sort (cost=34,264.86..34,264.86 rows=1 width=15) (actual time=912.742..912.758 rows=74 loops=1)

  • Sort Key: vendor_list_details.vendor_code
  • Sort Method: quicksort Memory: 28kB
3. 0.100 912.609 ↓ 74.0 74 1

Nested Loop (cost=12,976.23..34,264.85 rows=1 width=15) (actual time=534.397..912.609 rows=74 loops=1)

4. 5.022 912.205 ↓ 76.0 76 1

Nested Loop (cost=12,975.80..34,257.90 rows=1 width=23) (actual time=534.375..912.205 rows=76 loops=1)

5. 718.429 863.419 ↓ 41.4 6,252 1

Bitmap Heap Scan on vendor_list_details (cost=12,975.38..32,906.44 rows=151 width=15) (actual time=304.443..863.419 rows=6,252 loops=1)

  • Recheck Cond: (((is_rescinded)::text = 'false'::text) AND ((status)::text = ANY ('{4,7,8,9}'::text[])))
  • Rows Removed by Index Recheck: 2,415,886
  • Filter: ((vendor_code)::text = ANY ('{PRVT005561,PRVT005516,PRVT005476,PRVT005461,PRVT005456,PRVT005450,PRVT005446,PRVT005442,PRVT005428,PRVT005418,PRVT005091,PRVT003322}'::text[]))
  • Rows Removed by Filter: 223,219
  • Heap Blocks: exact=26,976 lossy=112,366
6. 11.043 144.990 ↓ 0.0 0 1

BitmapAnd (cost=12,975.38..12,975.38 rows=5,315 width=0) (actual time=144.990..144.990 rows=0 loops=1)

7. 84.100 84.100 ↓ 2.7 773,393 1

Bitmap Index Scan on vendor_list_details_is_rescinded (cost=0.00..6,446.79 rows=289,914 width=0) (actual time=84.100..84.100 rows=773,393 loops=1)

  • Index Cond: ((is_rescinded)::text = 'false'::text)
8. 49.847 49.847 ↓ 1.1 334,397 1

Bitmap Index Scan on idx_vendor_list_details_status (cost=0.00..6,528.26 rows=294,737 width=0) (actual time=49.846..49.847 rows=334,397 loops=1)

  • Index Cond: ((status)::text = ANY ('{4,7,8,9}'::text[]))
9. 43.764 43.764 ↓ 0.0 0 6,252

Index Scan using id_and_appt_idride_details_idx on ride_details (cost=0.43..8.95 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=6,252)

  • Index Cond: (id = vendor_list_details.ride_id)
  • Filter: ((cast_datetime_in_tz(datetime_in_tz) >= '2020-10-13'::date) AND (cast_datetime_in_tz(datetime_in_tz) <= '2020-10-13'::date))
  • Rows Removed by Filter: 1
10. 0.304 0.304 ↑ 1.0 1 76

Index Scan using ride_detail_id_unique on ride_additional_details (cost=0.43..6.95 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=76)

  • Index Cond: (ride_detail_id = ride_details.id)
  • Filter: ((mode)::text = '5001'::text)
  • Rows Removed by Filter: 0
Planning time : 2.319 ms
Execution time : 913.769 ms