explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NUDe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 118,046.768 ↓ 0.0 0 1

Limit (cost=1,000.88..831,056.47 rows=500 width=4) (actual time=118,046.768..118,046.768 rows=0 loops=1)

2. 0.002 118,046.768 ↓ 0.0 0 1

Unique (cost=1,000.88..3,854,118.90 rows=2,321 width=4) (actual time=118,046.767..118,046.768 rows=0 loops=1)

3. 2.825 118,046.766 ↓ 0.0 0 1

Nested Loop (cost=1,000.88..3,854,113.09 rows=2,321 width=4) (actual time=118,046.766..118,046.766 rows=0 loops=1)

  • Join Filter: (cts.identification_difficulty <= s.auto_accept_max_difficulty)
  • Rows Removed by Join Filter: 132
4. 1,030.201 117,995.893 ↑ 1.0 2,002 1

Nested Loop (cost=1,000.46..3,850,045.85 rows=2,022 width=12) (actual time=359.853..117,995.893 rows=2,002 loops=1)

  • Join Filter: (((s.auto_accept_taxa_filters IS NULL) OR (s.auto_accept_taxa_filters && delta.taxon_path)) AND (delta.survey_id = s.id))
  • Rows Removed by Join Filter: 3,430,612
5. 2,097.898 116,701.384 ↓ 2.8 264,308 1

Gather Merge (cost=1,000.46..3,829,886.20 rows=96,057 width=74) (actual time=320.891..116,701.384 rows=264,308 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
6. 114,603.486 114,603.486 ↓ 3.3 132,154 2 / 2

Parallel Index Scan Backward using pk_cache_occurrences_functional on cache_occurrences_functional delta (cost=0.43..3,817,798.81 rows=40,024 width=74) (actual time=14.294..114,603.486 rows=132,154 loops=2)

  • Index Cond: (id >= 1)
  • Filter: (data_cleaner_result AND (record_substatus IS NULL) AND (record_status = 'C'::bpchar) AND (created_on >= to_timestamp('01/11/2019'::text, 'DD/MM/YYYY'::text)))
  • Rows Removed by Filter: 5,885,867
7. 264.010 264.308 ↓ 1.1 13 264,308

Materialize (cost=0.00..17.74 rows=12 width=45) (actual time=0.000..0.001 rows=13 loops=264,308)

8. 0.298 0.298 ↓ 1.1 13 1

Seq Scan on surveys s (cost=0.00..17.68 rows=12 width=45) (actual time=0.103..0.298 rows=13 loops=1)

  • Filter: (auto_accept AND (NOT deleted))
  • Rows Removed by Filter: 556
9. 48.048 48.048 ↓ 0.0 0 2,002

Index Scan using fki_taxon_searchterms_taxon_meaning_id on cache_taxon_searchterms cts (cost=0.42..1.97 rows=3 width=8) (actual time=0.024..0.024 rows=0 loops=2,002)

  • Index Cond: (taxon_meaning_id = delta.taxon_meaning_id)
  • Filter: (identification_difficulty IS NOT NULL)
  • Rows Removed by Filter: 11