#	exclusive	inclusive	rows x	rows	loops	node
1.	0.324	30.040	↑ 1.0	1,000	1	→ Limit (cost=1,000.43..6,649.97 rows=1,000 width=368) (actual time=1.688..30.040 rows=1,000 loops=1) Buffers: shared hit=258 read=2 I/O Timings: read=21.340
2.	9.400	29.716	↑ 77.5	1,000	1	→ Gather (cost=1,000.43..438,273.33 rows=77,537 width=368) (actual time=1.686..29.716 rows=1,000 loops=1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=258 read=2 I/O Timings: read=21.340
3.	1.502	20.316	↑ 5,708.0	566	3	→ Result (cost=0.43..429,519.63 rows=3,230,700 width=368) (actual time=0.139..20.316 rows=566 loops=3) Buffers: shared hit=258 read=2 I/O Timings: read=21.340
4.	10.713	18.814	↑ 5,708.0	566	3	→ ProjectSet (cost=0.43..98,372.88 rows=3,230,700 width=304) (actual time=0.127..18.814 rows=566 loops=3) Buffers: shared hit=258 read=2 I/O Timings: read=21.340
5.	0.000	8.101	↑ 79.4	407	3	→ Parallel Append (cost=0.43..80,119.43 rows=32,307 width=80) (actual time=0.051..8.101 rows=407 loops=3) Buffers: shared hit=258 read=2 I/O Timings: read=21.340
6.	1.125	1.125	↑ 59.2	481	1	→ Parallel Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1 (cost=0.43..49,739.39 rows=28,487 width=80) (actual time=0.075..1.125 rows=481 loops=1) Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371)) Buffers: shared hit=106
7.	11.305	11.305	↑ 46.3	370	2	→ Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..29,895.44 rows=17,122 width=80) (actual time=0.032..11.305 rows=370 loops=2) Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371)) Buffers: shared hit=152 read=2 I/O Timings: read=21.340
8.	0.001	0.001	↓ 0.0	0	1	→ Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=1) Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))

Limit  (cost=1000.43..6649.97 rows=1000 width=368) (actual time=1.688..30.040 rows=1000 loops=1)
  Buffers: shared hit=258 read=2
  I/O Timings: read=21.340
  ->  Gather  (cost=1000.43..438273.33 rows=77537 width=368) (actual time=1.686..29.716 rows=1000 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        Buffers: shared hit=258 read=2
        I/O Timings: read=21.340
        ->  Result  (cost=0.43..429519.63 rows=3230700 width=368) (actual time=0.139..20.316 rows=566 loops=3)
              Buffers: shared hit=258 read=2
              I/O Timings: read=21.340
              ->  ProjectSet  (cost=0.43..98372.88 rows=3230700 width=304) (actual time=0.127..18.814 rows=566 loops=3)
                    Buffers: shared hit=258 read=2
                    I/O Timings: read=21.340
                    ->  Parallel Append  (cost=0.43..80119.43 rows=32307 width=80) (actual time=0.051..8.101 rows=407 loops=3)
                          Buffers: shared hit=258 read=2
                          I/O Timings: read=21.340
                          ->  Parallel Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1  (cost=0.43..49739.39 rows=28487 width=80) (actual time=0.075..1.125 rows=481 loops=1)
                                Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
                                Buffers: shared hit=106
                          ->  Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2  (cost=0.43..29895.44 rows=17122 width=80) (actual time=0.032..11.305 rows=370 loops=2)
                                Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
                                Buffers: shared hit=152 read=2
                                I/O Timings: read=21.340
                          ->  Parallel Seq Scan on delivery d  (cost=0.00..0.00 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=1)
                                Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
Planning Time: 34.542 ms
Execution Time: 30.367 ms

Per node type stats

node type	count	sum of times	% of query
Gather	1	9.400 ms	31.3 %
Limit	1	0.324 ms	1.1 %
Parallel Append	1	0.000 ms	0.0 %
Parallel Index Scan	2	12.430 ms	41.4 %
Parallel Seq Scan	1	0.001 ms	0.0 %
ProjectSet	1	10.713 ms	35.7 %
Result	1	1.502 ms	5.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
delivery	1	0.001 ms	0.0 %
Parallel Seq Scan	1	0.001 ms	100.0 %
delivery_1549144800	1	1.125 ms	3.7 %
Parallel Index Scan	1	1.125 ms	100.0 %
delivery_1549231200	1	11.305 ms	37.6 %
Parallel Index Scan	1	11.305 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ce8k : delivery_analytics2a

Color mode:

Visible columns:

Per node type stats

Per table stats