#	exclusive	inclusive	rows x	rows	loops	node
1.	0.289	14.894	↑ 1.0	1	1	→ Aggregate (cost=4,644.29..4,644.30 rows=1 width=16) (actual time=14.894..14.894 rows=1 loops=1) Buffers: shared hit=134 read=26 I/O Timings: read=0.214
2.	1.773	14.605	↑ 1.0	1,000	1	→ Limit (cost=1,000.00..4,629.29 rows=1,000 width=8) (actual time=1.699..14.605 rows=1,000 loops=1) Buffers: shared hit=134 read=26 I/O Timings: read=0.214
3.	0.000	12.832	↑ 902.2	1,000	1	→ Subquery Scan on bml_vbase_delivery_analytics (cost=1,000.00..3,275,195.77 rows=902,158 width=8) (actual time=1.697..12.832 rows=1,000 loops=1) Buffers: shared hit=88
4.	7.979	13.920	↑ 902.2	1,000	1	→ Gather (cost=1,000.00..3,266,174.19 rows=902,158 width=368) (actual time=1.697..13.920 rows=1,000 loops=1) Workers Planned: 3 Workers Launched: 3 Buffers: shared hit=134 read=26 I/O Timings: read=0.214
5.	0.522	5.941	↑ 115,943.8	251	4	→ Result (cost=0.00..3,174,958.39 rows=29,101,900 width=368) (actual time=0.120..5.941 rows=251 loops=4) Buffers: shared hit=134 read=26 I/O Timings: read=0.214
6.	4.913	5.419	↑ 115,943.8	251	4	→ ProjectSet (cost=0.00..337,523.14 rows=29,101,900 width=264) (actual time=0.111..5.419 rows=251 loops=4) Buffers: shared hit=134 read=26 I/O Timings: read=0.214
7.	0.000	0.506	↑ 1,616.8	180	4	→ Parallel Append (cost=0.00..173,097.41 rows=291,019 width=1,252) (actual time=0.045..0.506 rows=180 loops=4) Buffers: shared hit=134 read=26 I/O Timings: read=0.214
8.	0.485	0.485	↑ 1,751.3	96	2	→ Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_1 (cost=0.42..97,292.63 rows=168,128 width=1,249) (actual time=0.056..0.485 rows=96 loops=2) Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903)) Buffers: shared hit=26 read=26 I/O Timings: read=0.214
9.	0.351	0.351	↑ 462.0	266	2	→ Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_2 (cost=0.42..71,439.49 rows=122,890 width=1,255) (actual time=0.028..0.351 rows=266 loops=2) Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903)) Buffers: shared hit=108
10.	0.001	0.001	↓ 0.0	0	1	→ Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1) Filter: ((endtime >= 1549270503) AND (endtime <= 1549356903))

Aggregate  (cost=4644.29..4644.30 rows=1 width=16) (actual time=14.894..14.894 rows=1 loops=1)
  Buffers: shared hit=134 read=26
  I/O Timings: read=0.214
  ->  Limit  (cost=1000.00..4629.29 rows=1000 width=8) (actual time=1.699..14.605 rows=1000 loops=1)
        Buffers: shared hit=134 read=26
        I/O Timings: read=0.214
        ->  Subquery Scan on bml_vbase_delivery_analytics  (cost=1000.00..3275195.77 rows=902158 width=8) (actual time=1.697..12.832 rows=1000 loops=1)
              Buffers: shared hit=88
              ->  Gather  (cost=1000.00..3266174.19 rows=902158 width=368) (actual time=1.697..13.920 rows=1000 loops=1)
                    Workers Planned: 3
                    Workers Launched: 3
                    Buffers: shared hit=134 read=26
                    I/O Timings: read=0.214
                    ->  Result  (cost=0.00..3174958.39 rows=29101900 width=368) (actual time=0.120..5.941 rows=251 loops=4)
                          Buffers: shared hit=134 read=26
                          I/O Timings: read=0.214
                          ->  ProjectSet  (cost=0.00..337523.14 rows=29101900 width=264) (actual time=0.111..5.419 rows=251 loops=4)
                                Buffers: shared hit=134 read=26
                                I/O Timings: read=0.214
                                ->  Parallel Append  (cost=0.00..173097.41 rows=291019 width=1252) (actual time=0.045..0.506 rows=180 loops=4)
                                      Buffers: shared hit=134 read=26
                                      I/O Timings: read=0.214
                                      ->  Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_1  (cost=0.42..97292.63 rows=168128 width=1249) (actual time=0.056..0.485 rows=96 loops=2)
                                            Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903))
                                            Buffers: shared hit=26 read=26
                                            I/O Timings: read=0.214
                                      ->  Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_2  (cost=0.42..71439.49 rows=122890 width=1255) (actual time=0.028..0.351 rows=266 loops=2)
                                            Index Cond: ((endtime >= 1549270503) AND (endtime <= 1549356903))
                                            Buffers: shared hit=108
                                      ->  Parallel Seq Scan on delivery d  (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)
                                            Filter: ((endtime >= 1549270503) AND (endtime <= 1549356903))
Planning Time: 39.475 ms
Execution Time: 14.985 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.289 ms	1.9 %
Gather	1	7.979 ms	53.6 %
Limit	1	1.773 ms	11.9 %
Parallel Append	1	0.000 ms	0.0 %
Parallel Index Scan	2	0.836 ms	5.6 %
Parallel Seq Scan	1	0.001 ms	0.0 %
ProjectSet	1	4.913 ms	33.0 %
Result	1	0.522 ms	3.5 %
Subquery Scan	1	0.000 ms	0.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_1549231200	1	0.485 ms	3.3 %
Parallel Index Scan	1	0.485 ms	100.0 %
delivery_1549317600	1	0.351 ms	2.4 %
Parallel Index Scan	1	0.351 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 12Ir : delivery_warmed

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats