explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7N1d

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

Group (cost=283.47..283.48 rows=1 width=62) (actual time=6.929..6.929 rows=0 loops=1)

  • Group Key: query.human_document, query.full_name
2. 0.009 6.929 ↓ 0.0 0 1

Sort (cost=283.47..283.48 rows=1 width=62) (actual time=6.929..6.929 rows=0 loops=1)

  • Sort Key: query.human_document, query.full_name
  • Sort Method: quicksort Memory: 25kB
3. 0.001 6.920 ↓ 0.0 0 1

Subquery Scan on query (cost=283.43..283.46 rows=1 width=62) (actual time=6.920..6.920 rows=0 loops=1)

4. 0.002 6.919 ↓ 0.0 0 1

GroupAggregate (cost=283.43..283.45 rows=1 width=78) (actual time=6.919..6.919 rows=0 loops=1)

  • Group Key: human.human_document, (date_part('month'::text, flight.date_from))
  • Filter: (count(*) >= 2)
5. 0.100 6.917 ↓ 0.0 0 1

Sort (cost=283.43..283.43 rows=1 width=70) (actual time=6.917..6.917 rows=0 loops=1)

  • Sort Key: human.human_document, (date_part('month'::text, flight.date_from))
  • Sort Method: quicksort Memory: 25kB
6. 0.000 6.817 ↓ 0.0 0 1

Nested Loop (cost=4.72..283.42 rows=1 width=70) (actual time=6.817..6.817 rows=0 loops=1)

7. 0.001 6.817 ↓ 0.0 0 1

Nested Loop (cost=4.30..280.11 rows=1 width=66) (actual time=6.817..6.817 rows=0 loops=1)

8. 6.816 6.816 ↓ 0.0 0 1

Seq Scan on human (cost=0.00..269.25 rows=1 width=62) (actual time=6.815..6.816 rows=0 loops=1)

  • Filter: ((full_name)::text ~~ '%Андрей%'::text)
  • Rows Removed by Filter: 10100
9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ticket (cost=4.30..10.84 rows=2 width=16) (never executed)

  • Recheck Cond: ((human_document)::text = (human.human_document)::text)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on td (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: ((human_document)::text = (human.human_document)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using flight_pkey on flight (cost=0.42..3.30 rows=1 width=12) (never executed)

  • Index Cond: (id_flight = ticket.flight)
  • Filter: (date_from >= (CURRENT_DATE - 365))
Planning time : 9.139 ms
Execution time : 7.251 ms