explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I00

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.312 ↓ 0.0 0 1

Group (cost=4,001.50..4,001.53 rows=1 width=448) (actual time=0.312..0.312 rows=0 loops=1)

  • Group Key: "NonProfitOrganization".id
2. 0.004 0.312 ↓ 0.0 0 1

Sort (cost=4,001.50..4,001.52 rows=5 width=448) (actual time=0.312..0.312 rows=0 loops=1)

  • Sort Key: "NonProfitOrganization".id
  • Sort Method: quicksort Memory: 25kB
3. 0.005 0.308 ↓ 0.0 0 1

Hash Right Join (cost=44.78..4,001.45 rows=5 width=448) (actual time=0.307..0.308 rows=0 loops=1)

  • Hash Cond: (locations."npoId" = "NonProfitOrganization".id)
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on "npoLocations" locations (cost=0.00..3,739.21 rows=82,821 width=8) (never executed)

5. 0.001 0.303 ↓ 0.0 0 1

Hash (cost=44.76..44.76 rows=1 width=448) (actual time=0.303..0.303 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.001 0.302 ↓ 0.0 0 1

Bitmap Heap Scan on "nonProfitOrganizations" "NonProfitOrganization" (cost=40.25..44.76 rows=1 width=448) (actual time=0.302..0.302 rows=0 loops=1)

  • Recheck Cond: (npo_make_tsvector("NonProfitOrganization".*) @@ plainto_tsquery('group'::text))
  • Filter: (NOT "isSuspended")
7. 0.301 0.301 ↓ 0.0 0 1

Bitmap Index Scan on "nonProfitOrganizations-full-text-vector" (cost=0.00..40.25 rows=1 width=0) (actual time=0.300..0.301 rows=0 loops=1)

  • Index Cond: (npo_make_tsvector("NonProfitOrganization".*) @@ plainto_tsquery('group'::text))
Planning time : 0.755 ms
Execution time : 0.404 ms