explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7PQ1s

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 4,336.855 ↑ 1.0 5 1

Limit (cost=5.52..45.81 rows=5 width=55) (actual time=4,336.676..4,336.855 rows=5 loops=1)

2. 0.014 4,336.848 ↑ 18,193.8 5 1

Merge Append (cost=5.52..732,985.70 rows=90,969 width=55) (actual time=4,336.674..4,336.848 rows=5 loops=1)

  • Sort Key: measuremen0_.occurred DESC
3. 545.063 545.063 ↓ 0.0 0 1

Index Scan Backward using measurement2018_10_occurred_index on measurement_2018_10 measuremen0_ (cost=0.43..39,981.58 rows=2,301 width=55) (actual time=545.063..545.063 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 1,242,363
4. 933.957 933.957 ↓ 0.0 0 1

Index Scan Backward using measurement2018_11_occurred_index on measurement_2018_11 measuremen0__1 (cost=0.43..97,117.35 rows=5,784 width=55) (actual time=933.957..933.957 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 3,006,766
5. 1,129.550 1,129.550 ↓ 0.0 0 1

Index Scan Backward using measurement2018_12_occurred_index on measurement_2018_12 measuremen0__2 (cost=0.43..102,219.88 rows=5,782 width=55) (actual time=1,129.550..1,129.550 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 3,137,786
6. 915.026 915.026 ↓ 0.0 0 1

Index Scan Backward using measurement2019_01_occurred_index on measurement_2019_01 measuremen0__3 (cost=0.43..69,900.73 rows=2,992 width=55) (actual time=915.025..915.026 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 2,178,246
7. 444.406 444.406 ↓ 0.0 0 1

Index Scan Backward using measurement2019_02_occurred_index on measurement_2019_02 measuremen0__4 (cost=0.43..42,072.52 rows=1,273 width=55) (actual time=444.406..444.406 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 1,319,394
8. 363.952 363.952 ↓ 0.0 0 1

Index Scan Backward using measurement2019_03_occurred_index on measurement_2019_03 measuremen0__5 (cost=0.43..45,832.94 rows=1,528 width=55) (actual time=363.952..363.952 rows=0 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 1,437,738
9. 2.223 2.223 ↑ 10,283.0 1 1

Index Scan Backward using measurement2019_04_occurred_index on measurement_2019_04 measuremen0__6 (cost=0.43..54,622.98 rows=10,283 width=55) (actual time=2.223..2.223 rows=1 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 11,124
10. 2.320 2.320 ↑ 12,447.0 1 1

Index Scan Backward using measurement2019_05_occurred_index on measurement_2019_05 measuremen0__7 (cost=0.43..54,858.86 rows=12,447 width=55) (actual time=2.320..2.320 rows=1 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 10,157
11. 0.035 0.035 ↑ 11,183.0 1 1

Index Scan Backward using measurement2019_06_occurred_index on measurement_2019_06 measuremen0__8 (cost=0.43..60,077.54 rows=11,183 width=55) (actual time=0.035..0.035 rows=1 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 88
12. 0.043 0.043 ↑ 12,759.0 1 1

Index Scan Backward using measurement2019_07_occurred_index on measurement_2019_07 measuremen0__9 (cost=0.43..56,290.08 rows=12,759 width=55) (actual time=0.043..0.043 rows=1 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 126
13. 0.036 0.036 ↑ 13,776.0 1 1

Index Scan Backward using measurement2019_08_occurred_index on measurement_2019_08 measuremen0__10 (cost=0.43..57,781.95 rows=13,776 width=55) (actual time=0.036..0.036 rows=1 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 122
14. 0.213 0.213 ↑ 2,172.0 5 1

Index Scan Backward using measurement2019_09_occurred_index on measurement_2019_09 measuremen0__11 (cost=0.43..50,303.97 rows=10,860 width=55) (actual time=0.039..0.213 rows=5 loops=1)

  • Filter: (transaction_id = 809)
  • Rows Removed by Filter: 706
15. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using measurement2019_10_occurred_index on measurement_2019_10 measuremen0__12 (cost=0.14..14.52 rows=1 width=568) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (transaction_id = 809)
Planning time : 0.624 ms
Execution time : 4,336.996 ms