explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PuGyM : explain_delivery

Settings
# exclusive inclusive rows x rows loops node
1. 0.313 81.812 ↑ 1.0 1,000 1

Limit (cost=0.06..45.26 rows=1,000 width=368) (actual time=77.013..81.812 rows=1,000 loops=1)

  • Buffers: shared hit=52902
2. 1.650 81.499 ↑ 45,560,000,000,000,000.0 1,000 1

Nested Loop (cost=0.06..2,059,404,040,404,208,640.00 rows=45,560,000,000,000,000,000 width=368) (actual time=77.011..81.499 rows=1,000 loops=1)

  • Buffers: shared hit=52902
3. 0.232 78.179 ↑ 1,364,071,856,287,425.2 334 1

Nested Loop (cost=0.05..9,204,040,404,208,904.00 rows=455,600,000,000,000,000 width=336) (actual time=76.997..78.179 rows=334 loops=1)

  • Buffers: shared hit=52902
4. 0.055 77.387 ↑ 40,678,571,428,571.4 112 1

Nested Loop (cost=0.04..92,040,404,208,904.70 rows=4,556,000,000,000,000 width=304) (actual time=76.990..77.387 rows=112 loops=1)

  • Buffers: shared hit=52902
5. 0.025 77.104 ↑ 1,198,947,368,421.1 38 1

Nested Loop (cost=0.04..920,404,208,904.68 rows=45,560,000,000,000 width=272) (actual time=76.983..77.104 rows=38 loops=1)

  • Buffers: shared hit=52902
6. 0.008 77.014 ↑ 35,046,153,846.2 13 1

Nested Loop (cost=0.03..9,204,208,904.68 rows=455,600,000,000 width=240) (actual time=76.975..77.014 rows=13 loops=1)

  • Buffers: shared hit=52902
7. 0.004 76.976 ↑ 911,200,000.0 5 1

Nested Loop (cost=0.02..92,208,904.67 rows=4,556,000,000 width=208) (actual time=76.967..76.976 rows=5 loops=1)

  • Buffers: shared hit=52902
8. 0.003 76.960 ↑ 22,780,000.0 2 1

Nested Loop (cost=0.01..1,088,904.66 rows=45,560,000 width=176) (actual time=76.959..76.960 rows=2 loops=1)

  • Buffers: shared hit=52902
9. 0.004 76.949 ↑ 455,600.0 1 1

Nested Loop (cost=0.01..177,704.65 rows=455,600 width=144) (actual time=76.948..76.949 rows=1 loops=1)

  • Buffers: shared hit=52902
10. 0.003 76.923 ↑ 4,556.0 1 1

Append (cost=0.00..168,592.64 rows=4,556 width=80) (actual time=76.922..76.923 rows=1 loops=1)

  • Buffers: shared hit=52902
11. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=80) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: ((endtime >= 1549007733) AND (endtime <= 1549009533))
12. 76.904 76.904 ↑ 4,551.0 1 1

Seq Scan on delivery_1548972000 d_1 (cost=0.00..168,548.61 rows=4,551 width=80) (actual time=76.903..76.904 rows=1 loops=1)

  • Filter: ((endtime >= 1549007733) AND (endtime <= 1549009533))
  • Rows Removed by Filter: 309665
  • Buffers: shared hit=52902
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on delivery_1548979200 d_2 (cost=0.00..21.25 rows=4 width=80) (never executed)

  • Filter: ((endtime >= 1549007733) AND (endtime <= 1549009533))
14. 0.022 0.022 ↑ 100.0 1 1

Function Scan on jsonb_each esme_delivered (cost=0.01..1.01 rows=100 width=64) (actual time=0.022..0.022 rows=1 loops=1)

15. 0.008 0.008 ↑ 50.0 2 1

Function Scan on jsonb_each esme_total (cost=0.01..1.01 rows=100 width=32) (actual time=0.007..0.008 rows=2 loops=1)

16. 0.012 0.012 ↑ 50.0 2 2

Function Scan on jsonb_each esme_undelivered (cost=0.01..1.01 rows=100 width=32) (actual time=0.006..0.006 rows=2 loops=2)

17. 0.030 0.030 ↑ 33.3 3 5

Function Scan on jsonb_each esme_pending (cost=0.01..1.01 rows=100 width=32) (actual time=0.005..0.006 rows=3 loops=5)

18. 0.065 0.065 ↑ 33.3 3 13

Function Scan on jsonb_each esme_failed (cost=0.01..1.01 rows=100 width=32) (actual time=0.005..0.005 rows=3 loops=13)

19. 0.228 0.228 ↑ 33.3 3 38

Function Scan on jsonb_each esme_percent_pend_w (cost=0.01..1.01 rows=100 width=32) (actual time=0.005..0.006 rows=3 loops=38)

20. 0.560 0.560 ↑ 33.3 3 112

Function Scan on jsonb_each esme_percent_pend (cost=0.01..1.01 rows=100 width=32) (actual time=0.005..0.005 rows=3 loops=112)

21. 1.670 1.670 ↑ 33.3 3 334

Function Scan on jsonb_each esme_pending_weighted (cost=0.01..1.01 rows=100 width=32) (actual time=0.005..0.005 rows=3 loops=334)