explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LSXZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8,091.721 ↓ 0.0 0 1

Group (cost=6,108.93..6,108.94 rows=2 width=448) (actual time=8,091.721..8,091.721 rows=0 loops=1)

  • Group Key: "NonProfitOrganization".id
2. 0.004 8,091.720 ↓ 0.0 0 1

Sort (cost=6,108.93..6,108.93 rows=2 width=448) (actual time=8,091.720..8,091.720 rows=0 loops=1)

  • Sort Key: "NonProfitOrganization".id
  • Sort Method: quicksort Memory: 25kB
3. 7,994.654 8,091.716 ↓ 0.0 0 1

Hash Right Join (cost=1,663.08..6,108.92 rows=2 width=448) (actual time=8,091.716..8,091.716 rows=0 loops=1)

  • Hash Cond: (locations."npoId" = "NonProfitOrganization".id)
  • Filter: ((npo_make_tsvector("NonProfitOrganization".*) @@ plainto_tsquery('group'::text)) OR ((locations."zipCode")::text = 'test'::text))
  • Rows Removed by Filter: 92912
4. 36.258 36.258 ↑ 1.0 92,910 1

Seq Scan on "npoLocations" locations (cost=0.00..4,198.90 rows=93,090 width=10) (actual time=0.009..36.258 rows=92,910 loops=1)

5. 25.001 60.804 ↑ 1.0 18,584 1

Hash (cost=1,429.70..1,429.70 rows=18,670 width=920) (actual time=60.804..60.804 rows=18,584 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 16792kB
6. 35.803 35.803 ↑ 1.0 18,584 1

Seq Scan on "nonProfitOrganizations" "NonProfitOrganization" (cost=0.00..1,429.70 rows=18,670 width=920) (actual time=0.016..35.803 rows=18,584 loops=1)

  • Filter: (NOT "isSuspended")
Planning time : 1.668 ms
Execution time : 8,091.864 ms