explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vBsh

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 253.916 ↓ 0.0 0 1

Insert on tmpt (cost=9,640.75..11,761.58 rows=500 width=357) (actual time=253.916..253.916 rows=0 loops=1)

  • Buffers: shared hit=8 read=234
2. 0.001 253.912 ↓ 0.0 0 1

Nested Loop Left Join (cost=9,640.75..11,761.58 rows=500 width=357) (actual time=253.912..253.912 rows=0 loops=1)

  • Buffers: shared hit=8 read=234
3. 0.001 253.911 ↓ 0.0 0 1

Limit (cost=9,640.33..9,641.58 rows=500 width=220) (actual time=253.911..253.911 rows=0 loops=1)

  • Buffers: shared hit=8 read=234
4. 0.060 253.910 ↓ 0.0 0 1

Sort (cost=9,640.33..9,758.95 rows=47,449 width=220) (actual time=253.909..253.910 rows=0 loops=1)

  • Sort Key: segment_event_operational_snapshot.modified_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8 read=234
5. 0.101 253.850 ↓ 0.0 0 1

Hash Join (cost=46.25..7,276.00 rows=47,449 width=220) (actual time=253.850..253.850 rows=0 loops=1)

  • Hash Cond: (segment_event_operational_snapshot.vehicle_sid = vehicle.vehicle_sid)
  • Buffers: shared hit=5 read=234
6. 0.002 253.741 ↑ 49,755.0 1 1

Append (cost=0.00..7,096.59 rows=49,755 width=116) (actual time=253.741..253.741 rows=1 loops=1)

  • Buffers: shared hit=2 read=234
7. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on segment_event_operational_snapshot (cost=0.00..0.00 rows=1 width=116) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
8. 141.146 141.146 ↓ 0.0 0 1

Index Scan using ix_segment_event_operational_snapshot_12_p2019_10 on segment_event_operational_snapshot_p2019_10 (cost=0.29..689.36 rows=1 width=116) (actual time=141.146..141.146 rows=0 loops=1)

  • Index Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
  • Buffers: shared read=187
9. 10.083 112.587 ↑ 2,560.0 1 1

Bitmap Heap Scan on segment_event_operational_snapshot_p2020_02 (cost=163.60..891.33 rows=2,560 width=116) (actual time=112.587..112.587 rows=1 loops=1)

  • Recheck Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
  • Filter: ((modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
  • Heap Blocks: exact=1
  • Buffers: shared hit=2 read=47
10. 102.504 102.504 ↑ 1.0 6,987 1

Bitmap Index Scan on ix_segment_event_operational_snapshot_05_p2020_02 (cost=0.00..162.97 rows=7,068 width=0) (actual time=102.504..102.504 rows=6,987 loops=1)

  • Index Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
  • Buffers: shared hit=2 read=46
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_segment_event_operational_snapshot_12_p2019_11 on segment_event_operational_snapshot_p2019_11 (cost=0.41..887.65 rows=1 width=116) (never executed)

  • Index Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
12. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on segment_event_operational_snapshot_p2019_12 (cost=794.38..1,487.30 rows=1,398 width=116) (never executed)

  • Recheck Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
13. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_segment_event_operational_snapshot_12_p2019_12 (cost=0.00..794.03 rows=1,398 width=0) (never executed)

  • Index Cond: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on segment_event_operational_snapshot_p2020_01 (cost=0.00..3,140.96 rows=45,794 width=116) (never executed)

  • Filter: ((gps_date_time > '2019-10-09 21:01:36.991'::timestamp without time zone) AND (gps_date_time <= '2020-02-06 08:07:47.32853'::timestamp without time zone) AND (modified_date >= '2020-01-07 21:01:36.991'::timestamp without time zone) AND (modified_date <= '2020-02-06 08:07:47.32853'::timestamp without time zone))
15. 0.001 0.008 ↓ 0.0 0 1

Hash (cost=27.40..27.40 rows=580 width=112) (actual time=0.007..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on _filtered_vehicles vehicle (cost=0.00..27.40 rows=580 width=112) (actual time=0.006..0.007 rows=0 loops=1)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_dim_dim_driver_01 on dim_dim_driver (cost=0.42..4.17 rows=1 width=28) (never executed)

  • Index Cond: (segment_event_operational_snapshot.driver_sid = driver_sid)
Planning time : 823.356 ms
Execution time : 254.489 ms