explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ba0j

Settings
# exclusive inclusive rows x rows loops node
1. 40.665 6,615.072 ↑ 1.0 1 1

Gather (cost=1,004.55..1,158.84 rows=1 width=141) (actual time=6,583.765..6,615.072 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.013 6,574.407 ↑ 1.0 1 1

Limit (cost=4.55..158.74 rows=1 width=141) (actual time=6,574.398..6,574.407 rows=1 loops=1)

3. 0.009 6,574.394 ↑ 4,588.0 1 1

Merge Append (cost=4.55..707,440.50 rows=4,588 width=141) (actual time=6,574.394..6,574.394 rows=1 loops=1)

  • Sort Key: outcoming_2018_06.id DESC
4. 0.018 0.018 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_06_pk on outcoming_2018_06 (cost=0.14..45.74 rows=1 width=990) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
5. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_07_pk on outcoming_2018_07 (cost=0.14..45.74 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
6. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_08_pk on outcoming_2018_08 (cost=0.14..45.74 rows=1 width=990) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
7. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_09_pk on outcoming_2018_09 (cost=0.14..45.74 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
8. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_10_pk on outcoming_2018_10 (cost=0.14..45.74 rows=1 width=990) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
9. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_11_pk on outcoming_2018_11 (cost=0.14..45.74 rows=1 width=990) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
10. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using outcoming_2018_12_pk on outcoming_2018_12 (cost=0.14..45.74 rows=1 width=990) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
11. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_01_pk on outcoming_2019_01 (cost=0.14..45.74 rows=1 width=990) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
12. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_02_pk on outcoming_2019_02 (cost=0.14..45.74 rows=1 width=990) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
13. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_03_pk on outcoming_2019_03 (cost=0.14..45.74 rows=1 width=990) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
14. 0.012 0.012 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_04_pk on outcoming_2019_04 (cost=0.14..45.74 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
15. 6,573.908 6,573.908 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_05_pk on outcoming_2019_05 (cost=0.43..590,407.41 rows=3,813 width=137) (actual time=6,573.908..6,573.908 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
  • Rows Removed by Filter: 10743600
16. 0.126 0.126 ↑ 753.0 1 1

Index Scan Backward using outcoming_2019_06_pk on outcoming_2019_06 (cost=0.43..115,909.56 rows=753 width=137) (actual time=0.126..0.126 rows=1 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
17. 0.028 0.028 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_07_pk on outcoming_2019_07 (cost=0.14..45.74 rows=1 width=990) (actual time=0.028..0.028 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
18. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_08_pk on outcoming_2019_08 (cost=0.14..45.74 rows=1 width=990) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
19. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_09_pk on outcoming_2019_09 (cost=0.14..45.74 rows=1 width=990) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
20. 0.020 0.020 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_10_pk on outcoming_2019_10 (cost=0.14..45.74 rows=1 width=990) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
21. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_11_pk on outcoming_2019_11 (cost=0.14..45.74 rows=1 width=990) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
22. 0.024 0.024 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_12_pk on outcoming_2019_12 (cost=0.14..45.74 rows=1 width=990) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
23. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using outcoming_2020_01_pk on outcoming_2020_01 (cost=0.14..45.74 rows=1 width=990) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
24. 0.017 0.017 ↓ 0.0 0 1

Index Scan Backward using outcoming_2020_02_pk on outcoming_2020_02 (cost=0.14..45.74 rows=1 width=990) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
25. 0.031 0.031 ↓ 0.0 0 1

Index Scan Backward using outcoming_2020_03_pk on outcoming_2020_03 (cost=0.14..45.74 rows=1 width=990) (actual time=0.031..0.031 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
26. 0.016 0.016 ↓ 0.0 0 1

Index Scan Backward using outcoming_2020_04_pk on outcoming_2020_04 (cost=0.14..45.74 rows=1 width=990) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
27. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using outcoming_2020_05_pk on outcoming_2020_05 (cost=0.14..45.74 rows=1 width=990) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
Planning time : 2.415 ms
Execution time : 6,615.450 ms