explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4E6V

Settings
# exclusive inclusive rows x rows loops node
1. 10.900 17.006 ↓ 0.0 0 1

Gather (cost=22,666.64..22,666.74 rows=1 width=239) (actual time=14.784..17.006 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.003 6.106 ↓ 0.0 0 1

Limit (cost=21,666.64..21,666.64 rows=1 width=239) (actual time=6.106..6.106 rows=0 loops=1)

3. 0.094 6.103 ↓ 0.0 0 1

Sort (cost=21,666.64..21,667.10 rows=183 width=239) (actual time=6.103..6.103 rows=0 loops=1)

  • Sort Key: outcoming_2018_06.datetime_create
4. 0.003 6.009 ↓ 0.0 0 1

Append (cost=0.14..21,665.73 rows=183 width=239) (actual time=6.009..6.009 rows=0 loops=1)

5. 0.020 0.020 ↓ 0.0 0 1

Index Scan using outcoming_2018_06_postamat_id_status_index on outcoming_2018_06 (cost=0.14..8.16 rows=1 width=990) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
6. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2018_07_postamat_id_status_index on outcoming_2018_07 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
7. 0.013 0.013 ↓ 0.0 0 1

Index Scan using outcoming_2018_08_postamat_id_status_index on outcoming_2018_08 (cost=0.14..8.16 rows=1 width=990) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
8. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2018_09_postamat_id_status_index on outcoming_2018_09 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
9. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2018_10_postamat_id_status_index on outcoming_2018_10 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2018_11_postamat_id_status_index on outcoming_2018_11 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
11. 0.018 0.018 ↓ 0.0 0 1

Index Scan using outcoming_2018_12_postamat_id_status_index on outcoming_2018_12 (cost=0.14..8.16 rows=1 width=990) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
12. 0.012 0.012 ↓ 0.0 0 1

Index Scan using outcoming_2019_01_postamat_id_status_index on outcoming_2019_01 (cost=0.14..8.16 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
13. 0.018 0.018 ↓ 0.0 0 1

Index Scan using outcoming_2019_02_postamat_id_status_index on outcoming_2019_02 (cost=0.14..8.16 rows=1 width=990) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
14. 0.017 0.017 ↓ 0.0 0 1

Index Scan using outcoming_2019_03_postamat_id_status_index on outcoming_2019_03 (cost=0.14..8.16 rows=1 width=990) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
15. 0.012 0.012 ↓ 0.0 0 1

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

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
16. 0.005 0.059 ↓ 0.0 0 1

Bitmap Heap Scan on outcoming_2019_05 (cost=118.19..17,924.29 rows=135 width=137) (actual time=0.059..0.059 rows=0 loops=1)

  • Recheck Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
17. 0.054 0.054 ↓ 0.0 0 1

Bitmap Index Scan on outcoming_2019_05_postamat_id_status_index (cost=0.00..118.16 rows=5,030 width=0) (actual time=0.053..0.054 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
18. 3.899 5.650 ↓ 0.0 0 1

Bitmap Heap Scan on outcoming_2019_06 (cost=23.94..3,561.86 rows=26 width=137) (actual time=5.650..5.650 rows=0 loops=1)

  • Recheck Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
  • Rows Removed by Filter: 106
19. 1.751 1.751 ↓ 13.9 13,919 1

Bitmap Index Scan on outcoming_2019_06_postamat_id_status_index (cost=0.00..23.93 rows=1,000 width=0) (actual time=1.751..1.751 rows=13,919 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
20. 0.012 0.012 ↓ 0.0 0 1

Index Scan using outcoming_2019_07_postamat_id_status_index on outcoming_2019_07 (cost=0.14..8.16 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
21. 0.012 0.012 ↓ 0.0 0 1

Index Scan using outcoming_2019_08_postamat_id_status_index on outcoming_2019_08 (cost=0.14..8.16 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan using outcoming_2019_09_postamat_id_status_index on outcoming_2019_09 (cost=0.14..8.16 rows=1 width=990) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
23. 0.008 0.008 ↓ 0.0 0 1

Index Scan using outcoming_2019_10_postamat_id_status_index on outcoming_2019_10 (cost=0.14..8.16 rows=1 width=990) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
24. 0.010 0.010 ↓ 0.0 0 1

Index Scan using outcoming_2019_11_postamat_id_status_index on outcoming_2019_11 (cost=0.14..8.16 rows=1 width=990) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
25. 0.019 0.019 ↓ 0.0 0 1

Index Scan using outcoming_2019_12_postamat_id_status_index on outcoming_2019_12 (cost=0.14..8.16 rows=1 width=990) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
26. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2020_01_postamat_id_status_index on outcoming_2020_01 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
27. 0.014 0.014 ↓ 0.0 0 1

Index Scan using outcoming_2020_02_postamat_id_status_index on outcoming_2020_02 (cost=0.14..8.16 rows=1 width=990) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
28. 0.011 0.011 ↓ 0.0 0 1

Index Scan using outcoming_2020_03_postamat_id_status_index on outcoming_2020_03 (cost=0.14..8.16 rows=1 width=990) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
29. 0.012 0.012 ↓ 0.0 0 1

Index Scan using outcoming_2020_04_postamat_id_status_index on outcoming_2020_04 (cost=0.14..8.16 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
30. 0.013 0.013 ↓ 0.0 0 1

Index Scan using outcoming_2020_05_postamat_id_status_index on outcoming_2020_05 (cost=0.14..8.16 rows=1 width=990) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)