explain.depesz.com

PostgreSQL's explain analyze made readable

Result: clrZ

Settings
# exclusive inclusive rows x rows loops node
1. 10.863 941.418 ↑ 4.3 7 1

Index Scan using index_station_id on de_tt_priceinfo a (cost=0.57..1,764,713.65 rows=30 width=55) (actual time=9.649..941.418 rows=7 loops=1)

  • Index Cond: ((station_id)::text = ANY ('{BEC3EF55-,A24C612B-,578C44BB-,9982BE74-,F5137488-,6F2F48A8-,0C91A93A-}'::text[]))
  • Filter: (recieved = (SubPlan 2))
  • Rows Removed by Filter: 6886
2.          

SubPlan (for Index Scan)

3. 0.000 930.555 ↑ 1.0 1 6,893

Result (cost=291.15..291.16 rows=1 width=0) (actual time=0.135..0.135 rows=1 loops=6,893)

4.          

Initplan (for Result)

5. 0.000 930.555 ↑ 1.0 1 6,893

Limit (cost=0.56..291.15 rows=1 width=8) (actual time=0.135..0.135 rows=1 loops=6,893)

6. 930.555 930.555 ↑ 715.0 1 6,893

Index Only Scan Backward using de_tt_priceinfo_recieved_station_id_idx on de_tt_priceinfo b (cost=0.56..207,771.15 rows=715 width=8) (actual time=0.135..0.135 rows=1 loops=6,893)

  • Index Cond: ((recieved IS NOT NULL) AND (recieved <= '2014-09-25 08:45:12+02'::timestamp with time zone) AND (station_id = (a.station_id)::text))
  • Heap Fetches: 6893