explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ofJP : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.103 1,440.665 ↓ 11.0 11 1

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

  • Group Key: vendor_list_details.vendor_code
2. 0.148 1,440.562 ↓ 74.0 74 1

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

  • Sort Key: vendor_list_details.vendor_code
  • Sort Method: quicksort Memory: 28kB
3. 0.081 1,440.414 ↓ 74.0 74 1

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

4. 1.834 1,439.877 ↓ 76.0 76 1

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

5. 1,199.942 1,375.523 ↓ 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=411.731..1,375.523 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,923
  • 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,974 lossy=112,368
6. 10.634 175.581 ↓ 0.0 0 1

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

7. 109.246 109.246 ↓ 2.7 773,387 1

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

  • Index Cond: ((is_rescinded)::text = 'false'::text)
8. 55.701 55.701 ↓ 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=55.701..55.701 rows=334,397 loops=1)

  • Index Cond: ((status)::text = ANY ('{4,7,8,9}'::text[]))
9. 62.520 62.520 ↓ 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.010..0.010 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.456 0.456 ↑ 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.006..0.006 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.607 ms
Execution time : 1,441.583 ms