explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hF65

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 10,179.398 ↑ 1.0 50 1

Limit (cost=270,203.95..270,329.95 rows=50 width=2,654) (actual time=10,178.757..10,179.398 rows=50 loops=1)

2. 2.546 10,179.391 ↑ 1,805.6 50 1

Result (cost=270,203.95..497,714.59 rows=90,282 width=2,654) (actual time=10,178.756..10,179.391 rows=50 loops=1)

3. 12.674 10,176.845 ↑ 1,805.6 50 1

Sort (cost=270,203.95..270,429.66 rows=90,282 width=2,622) (actual time=10,176.840..10,176.845 rows=50 loops=1)

  • Sort Key: ((i.properties -> 'eo:cloud_cover'::text))
  • Sort Method: top-N heapsort Memory: 334kB
4. 452.079 10,164.171 ↑ 20.2 4,461 1

Hash Join (cost=1.04..267,204.85 rows=90,282 width=2,622) (actual time=2.895..10,164.171 rows=4,461 loops=1)

  • Hash Cond: ((i.collection)::text = (c.id)::text)
  • Join Filter: (((((i.properties ->> 'eo:cloud_cover'::text))::numeric < '30'::numeric) OR (((c.properties ->> 'eo:cloud_cover'::text))::numeric < '30'::numeric)) AND ((((i.properties ->> 'eo:cloud_cover'::text))::numeric > '25'::numeric) OR (((c.properties ->> 'eo:cloud_cover'::text))::numeric > '25'::numeric)))
  • Rows Removed by Join Filter: 198,967
5. 8,897.895 9,711.607 ↓ 1.0 203,428 1

Seq Scan on items i (cost=0.00..264,146.03 rows=199,708 width=1,477) (actual time=1.212..9,711.607 rows=203,428 loops=1)

  • Filter: ((datetime > '2017-04-05 00:00:00'::timestamp without time zone) AND (datetime < '2018-05-02 23:59:00'::timestamp without time zone))
  • Rows Removed by Filter: 844,646
6.          

SubPlan (for Seq Scan)

7. 406.856 813.712 ↑ 1.0 1 203,428

Result (cost=0.17..0.19 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=203,428)

8.          

Initplan (for Result)

9. 0.000 203.428 ↑ 1.0 1 203,428

Limit (cost=0.00..0.09 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=203,428)

10. 203.428 203.428 ↑ 150.0 1 203,428

Seq Scan on apiurls (cost=0.00..13.00 rows=150 width=32) (actual time=0.001..0.001 rows=1 loops=203,428)

11. 203.428 203.428 ↑ 1.0 1 203,428

Limit (cost=0.00..0.08 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=203,428)

12. 0.000 0.000 ↑ 150.0 1 203,428

Seq Scan on apiurls apiurls_1 (cost=0.00..12.25 rows=150 width=32) (actual time=0.000..0.000 rows=1 loops=203,428)

13. 0.005 0.485 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=1,127) (actual time=0.485..0.485 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
14. 0.480 0.480 ↑ 1.0 2 1

Seq Scan on collections c (cost=0.00..1.02 rows=2 width=1,127) (actual time=0.479..0.480 rows=2 loops=1)