explain.depesz.com

PostgreSQL's explain analyze made readable

Result: POoA

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 2,416.874 ↑ 1.0 100 1

Limit (cost=164,492.85..164,493.10 rows=100 width=74) (actual time=2,416.859..2,416.874 rows=100 loops=1)

2. 124.186 2,416.862 ↑ 7,496.5 100 1

Sort (cost=164,492.85..166,366.97 rows=749,648 width=74) (actual time=2,416.857..2,416.862 rows=100 loops=1)

  • Sort Key: fr.valid_from DESC
  • Sort Method: top-N heapsort Memory: 48kB
3. 626.297 2,292.676 ↑ 1.0 749,613 1

HashAggregate (cost=128,345.37..135,841.85 rows=749,648 width=74) (actual time=2,103.805..2,292.676 rows=749,613 loops=1)

  • Group Key: fr.id
4. 551.046 1,666.379 ↑ 1.0 1,413,490 1

Hash Join (cost=70,229.12..121,276.77 rows=1,413,719 width=74) (actual time=996.326..1,666.379 rows=1,413,490 loops=1)

  • Hash Cond: ((factual_report_subscore.factual_report_id)::text = (fr.id)::text)
5. 121.327 121.327 ↓ 1.0 1,413,855 1

Seq Scan on factual_report_subscore (cost=0.00..31,608.79 rows=1,413,779 width=33) (actual time=0.012..121.327 rows=1,413,855 loops=1)

6. 229.506 994.006 ↑ 1.0 749,613 1

Hash (cost=60,858.52..60,858.52 rows=749,648 width=91) (actual time=994.006..994.006 rows=749,613 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 102626kB
7. 279.196 764.500 ↑ 1.0 749,613 1

Hash Join (cost=41,763.60..60,858.52 rows=749,648 width=91) (actual time=381.205..764.500 rows=749,613 loops=1)

  • Hash Cond: ((factual_report_permission.factual_report_id)::text = (fr.id)::text)
8. 106.145 106.145 ↑ 1.0 749,613 1

Seq Scan on factual_report_permission (cost=0.00..17,127.00 rows=749,680 width=25) (actual time=0.011..106.145 rows=749,613 loops=1)

  • Filter: ((organization_id)::text = '59087ebe6acef17ef317c5c8'::text)
9. 204.701 379.159 ↑ 1.0 749,613 1

Hash (cost=32,393.00..32,393.00 rows=749,648 width=66) (actual time=379.158..379.159 rows=749,613 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 84325kB
10. 174.458 174.458 ↑ 1.0 749,613 1

Seq Scan on factual_report fr (cost=0.00..32,393.00 rows=749,648 width=66) (actual time=0.013..174.458 rows=749,613 loops=1)

  • Filter: ((epicenter_lat >= '-56.2999999999999972'::double precision) AND (epicenter_lat <= '72.0999999999999943'::double precision) AND (epicenter_long >= '-179'::double precision) AND (epicenter_long <= '179'::double precision) AND (valid_to >= '2003-01-01 08:57:01'::timestamp without time zone) AND (valid_from <= '2019-10-22 09:27:01'::timestamp without time zone))
Planning time : 3.383 ms
Execution time : 2,443.051 ms