explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L2FF

Settings
# exclusive inclusive rows x rows loops node
1. 0.595 11,764.286 ↑ 1.0 50 1

Limit (cost=650,263.12..650,389.37 rows=50 width=2,656) (actual time=11,763.364..11,764.286 rows=50 loops=1)

2. 3.689 11,763.691 ↑ 456.3 50 1

Result (cost=650,263.12..707,865.95 rows=22,813 width=2,656) (actual time=11,762.778..11,763.691 rows=50 loops=1)

3. 19.376 11,760.002 ↑ 456.3 50 1

Sort (cost=650,263.12..650,320.16 rows=22,813 width=2,624) (actual time=11,759.990..11,760.002 rows=50 loops=1)

  • Sort Key: ((COALESCE((i.properties -> 'eo:cloud_cover'::text), (c.properties -> 'eo:cloud_cover'::text)))::numeric)
  • Sort Method: top-N heapsort Memory: 342kB
4. 230.408 11,740.626 ↑ 1.4 15,862 1

Hash Join (cost=1.04..649,505.29 rows=22,813 width=2,624) (actual time=667.760..11,740.626 rows=15,862 loops=1)

  • Hash Cond: ((i.collection)::text = (c.id)::text)
  • Join Filter: (((COALESCE((i.properties -> 'eo:cloud_cover'::text), (c.properties -> 'eo:cloud_cover'::text)))::numeric >= '26'::numeric) AND ((COALESCE((i.properties -> 'eo:cloud_cover'::text), (c.properties -> 'eo:cloud_cover'::text)))::numeric <= '40'::numeric))
  • Rows Removed by Join Filter: 187566
5. 10,696.487 11,510.199 ↑ 1.0 203,428 1

Seq Scan on items i (cost=0.00..648,439.19 rows=205,313 width=1,479) (actual time=667.584..11,510.199 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: 844646
6.          

SubPlan (for Seq Scan)

7. 406.856 813.712 ↑ 1.0 1 203,428

Result (cost=2.04..2.05 rows=1 width=32) (actual time=0.003..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..1.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=203,428)

10. 203.428 203.428 ↑ 1.0 1 203,428

Seq Scan on apiurls (cost=0.00..1.02 rows=1 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..1.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=203,428)

12. 0.000 0.000 ↑ 1.0 1 203,428

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

13. 0.014 0.019 ↑ 1.0 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
14. 0.005 0.005 ↑ 1.0 2 1

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