explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JiJe

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 561.354 ↑ 1.0 1 1

Limit (cost=197,566.00..197,566.01 rows=1 width=331) (actual time=561.352..561.354 rows=1 loops=1)

2. 1.785 561.352 ↑ 1.0 1 1

Sort (cost=197,566.00..197,566.01 rows=1 width=331) (actual time=561.351..561.352 rows=1 loops=1)

  • Sort Key: utd.transmission_datetime DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 1.643 559.567 ↓ 2,547.0 2,547 1

Nested Loop (cost=0.99..197,565.99 rows=1 width=331) (actual time=0.082..559.567 rows=2,547 loops=1)

4. 2.849 2.849 ↓ 1.1 2,467 1

Index Scan using idx_utility_transmissions_property_utility_type_id on utility_transmissions ut (cost=0.42..2,186.97 rows=2,190 width=4) (actual time=0.020..2.849 rows=2,467 loops=1)

  • Index Cond: (property_utility_type_id = 1,104)
5. 555.075 555.075 ↑ 1.0 1 2,467

Index Scan using idx_utility_transmission_details_utility_transmission_id on utility_transmission_details utd (cost=0.56..89.20 rows=1 width=331) (actual time=0.191..0.225 rows=1 loops=2,467)

  • Index Cond: (utility_transmission_id = ut.id)
  • Filter: ((property_id = 44,555) AND (property_unit_id = 3,025,089) AND ((transmission_datetime)::date <= '10/12/2020'::date))
  • Rows Removed by Filter: 414
Planning time : 0.319 ms
Execution time : 561.405 ms